Re: When should one rebuild an index?

From: Bob Jones <email_at_me.not>
Date: Sat, 27 Dec 2008 10:45:12 -0600
Message-ID: <oYs5l.10821$>

"DA Morgan" <> wrote in message
> Bob Jones wrote:
>> <> wrote in message
>>> Hi
>>> We can use
>>> 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.
>> 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

Original text of this message