Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> When to rebuild the index?

When to rebuild the index?

From: Chirag DBA <chiragdba_at_gmail.com>
Date: Tue, 6 Sep 2005 12:04:27 -0400
Message-ID: <1a3629600509060904215cec90@mail.gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 06 2005 - 11:06:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US