When should one rebuild an index?

From: <shweta.kaparwan_at_googlemail.com>
Date: Fri, 26 Dec 2008 16:57:09 -0800 (PST)
Message-ID: <3bddc9d2-d04f-4525-9703-9c74ccd33d9e@h20g2000yqn.googlegroups.com>


We can use
ANALYZE INDEX <index> VALIDATE STRUCTURE  command on the affected indexes - each invocation of this command creates a single row in the INDEX_STATS view. Thus determining the indexes which are good candidates for rebuilding.

BUT my doubt is that if,
we use dbms_stats to gather the statstistics for CBO using cascade option. Then if
ANALYZE INDEX <index> VALIDATE STRUCTURE is ran , that what will be fate of the stattistics gathered using dbms_stat for index( cascade option).

Also, analyze command is deprecated now. So is there any other way to find out the indexes which needs rebuilding.?

Thanks. Received on Fri Dec 26 2008 - 18:57:09 CST

Original text of this message