Re: more index questions

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Thu, 21 Jun 2001 11:54:49 +0100
Message-ID: <993120829.910.0.nnrp-02.c30bdde2@news.demon.co.uk>

alter index xxx coalesce;
analyze index xxx validate structure;
select * from index_stats;

if height>3 rebuild

if del_lf_rows is significantly large % of lf_rows, rebuild.

That's about it I think.

<u518615722_at_spawnkill.ip-mobilphone.net> wrote in message news:l.993045842.1372711181@[198.138.198.252]...
> After the analyze index, how do you know whether an index needs
> to be rebuild? I check the DBA handbook, it only say after major
> data load, you need to rebuild an index. Is there more quatative
> way to measure an index's usefulness?
>
> Thanks
>
>
>
>
> --
> Sent by dbadba62 from hotmail in field com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Thu Jun 21 2001 - 05:54:49 CDT