Re: rebuild index

> Likely a complete waste of time and CPU. Rebuilding indexes is
> something you should only do when you have metrics supporting the
> fact that there is a need to do so.
>
> One way to determine whether an index requires rebuilding is to
> use the built in SYS_OP_LBID function. I have a demo of its usage
> in Morgan's Library under Undocumented Oracle and there is some
> documentation by Jonathan Lewis you can find if you google for
> the function by name.
> --

For determine if an index requires rebuild i use this method:

 analyze index IDXNAME validate_structure;

and after i verify INDEX_STATS table for result (LF_ROWS and DEL_LF_ROWS), if the ratio (DEL/LF) is more then 20% i rebuild index. Received on Fri Oct 06 2006 - 02:20:27 CDT