John, Would it be advisable to go for Index rebuilds in case of index based on monotonically increasing columns? As much as I understand (and I must admit, i don't know much about the internals of indexes), in case of such indexes the problem of 'leaf block split' should not happen. Regards Naveen >-----Original Message----- >From: John Kanagaraj [mailto:john.kanagaraj@xxxxxxx] >Sent: Wednesday, February 18, 2004 12:30 PM >To: 'oracle-l@xxxxxxxxxxxxx' >Subject: RE: Rebuild Indexes > > >Vidya, > >If you are collecting (and storing) STATSPACK data, you might want to >baseline V$SYSSTAT values and look for spurts in 'leaf node >splits' after >rebuilds.... > >John Kanagaraj <>< ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------