Re: When should one rebuild an index?
Date: Sat, 27 Dec 2008 10:45:12 -0600
Message-ID: <oYs5l.10821$yr3.9829@nlpi068.nbdc.sbc.com>
"DA Morgan" <damorgan_at_psoug.org> wrote in message
news:1230357209.294829_at_bubbleator.drizzle.com...
> Bob Jones wrote:
>> <shweta.kaparwan_at_googlemail.com> wrote in message
>> news:3bddc9d2-d04f-4525-9703-9c74ccd33d9e_at_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.
>>>
>>
>> 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