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>
Date: Fri, 26 Dec 2008 16:57:09 -0800 (PST)
Message-ID: <3bddc9d2-d04f-4525-9703-9c74ccd33d9e@h20g2000yqn.googlegroups.com>
Hi
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