Re: When should one rebuild an index?

From: Bob Jones <email_at_me.not>
Date: Fri, 26 Dec 2008 20:53:50 -0600
Message-ID: <%Mg5l.3876$jZ1.88@flpi144.ffdc.sbc.com>

<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. Received on Fri Dec 26 2008 - 20:53:50 CST

Original text of this message