Re: When should one rebuild an index?
Date: Sat, 27 Dec 2008 10:45:12 -0600
"DA Morgan" <damorgan_at_psoug.org> wrote in message
> Bob Jones wrote:
>> <shweta.kaparwan_at_googlemail.com> wrote in message
>>> 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
>>> Also, analyze command is deprecated now. So is there any other way to
>>> find out the indexes which needs rebuilding.?
>> INDEX_STATS is populated by ANALYZE only. Your CBO data collected by
>> DBMS_STATS are safe.
> The CBO data is safe but what you are suggesting as criteria irrelevant.
What criteria? Received on Sat Dec 27 2008 - 10:45:12 CST