Re: how can I check if a index is needed to be rebuild or not?

run
analyze index <index name> validate structure

on the affected index.
The results of this operation will be dumped in a table called index_stats. Note: this table has always only the last result. It will show you amongst others
blocks:
the total number of blocks allocated
btree_space:
the total size of the btree in bytes
used_space:
the number of bytes used in the tree
pct_used : the ratio of the previous
distinct_keys
the number of keys in the index
del_lf_rows:
the number of deleted rows

I usually decide on a low pct_used (below 80 percent) or a high number of deleted rows.

Hth,

Sybrand Bakker, Oracle DBA

"Cantonese Boy" <cantoneseboy_at_netscape.net> wrote in message news:3A4A1726.219EE6A7_at_netscape.net...
> As title, if my index is always has one extent,
> how can I know when there is a need to rebuild the index?
> I know that there may be some "holes" inside the index that will
> cause performance problem, how can I know?
>
> Thanks
>
> W
Received on Wed Dec 27 2000 - 12:02:53 CST