Re: When to rebuild the index?
- From: Chirag DBA <chiragdba@xxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- Date: Tue, 6 Sep 2005 14:22:52 -0400
Hi,
http://www.dba-oracle.com/art_dbazine_idx_rebuild.htm
Here is the very good document for indexes.
I just found that.
Regards - Chirag
On 9/6/05, Chirag DBA <chiragdba@xxxxxxxxx> wrote:
>
> Sure.. I thouht I miss to configure something.
> Let me do this and if I will come across something like this, I will be
> more than happy to share with you guys.
> Thank you,
> Regards - Chirag
>
> On 9/6/05, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:
> >
> > I know - it's kind of a pain. Search Metalink for index_stats and you
> > should find a script that you can run which will create a stored procedure
> > and generate a secondary script to run validate structure on each index and
> > then insert the values from index_stats into a secondary table, e.g.
> > all_index_stats.
> >
> > -----Original Message-----
> > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> > oracle-l-bounce@xxxxxxxxxxxxx]*On Behalf Of *Chirag DBA
> > *Sent:* Tuesday, September 06, 2005 10:07 AM
> > *To:* Chirag DBA
> > *Cc:* Oracle-L Freelists
> > *Subject:* Re: When to rebuild the index?
> >
> > While you do the validate structure with indexes, it shows the stats
> > only for the last index.
> > How can I see the list of all the indexes who needs to get rebuild now.
> > I can see the results only for 1 index and that is the last one in
> > valudate structure.
> > Regards - Chirag
> >
> > On 9/6/05, Chirag DBA <chiragdba@xxxxxxxxx > wrote:
> > >
> > > Hi Guys,
> > > I think that even select statement will make the index split and
> > > require the rebuilding. Am I true? I think I am.
> > > And there is a view called index_stats with column height.
> > > I have read that when the value of this column is >= 4, u need to
> > > rebuild the indexes.
> > > But after analyzing the particular schema, I don see any value to get
> > > populated in this view.
> > > I can see last analyzed value changed in dba_indexes when I analyze
> > > the schema with DBMS_STATS. ANALYZE_SCHEMA package.
> > > Why this is so?
> > > Regards - Chirag
> > >
> >
> > Privileged/Confidential Information may be contained in this message or
> > attachments hereto. Please advise immediately if you or your employer do
> > not
> > consent to Internet email for messages of this kind. Opinions, conclusions
> > and other information in this message that do not relate to the official
> > business of this company shall be understood as neither given nor endorsed
> > by it.
> >
>
>
Other related posts:
