Thanks for the info Cary. Jared
On Mon, 2003-10-20 at 09:29, Cary Millsap wrote: > Fyi, Oracle updated note 182699.1 last Friday. The inaccurate statements > about "index fragmentation" have been removed. > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > > Upcoming events: > - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney > - SQL Optimization 101: 12/8-12 Dallas > - Hotsos Symposium 2004: March 7-10 Dallas > - Visit www.hotsos.com for schedule details... > > > -----Original Message----- > Richard Foote > Sent: Friday, October 17, 2003 6:29 AM > To: Multiple recipients of list ORACLE-L > Separate > > Hi Hemant, > > One word perfectly describes the Metalink article you highlighted: > > Crap ;) > > A nice example of how Oracle Corp is the greatest myth generator of > them > all !! It's all rather sad and embarressing isn't. > > Thanks for the headsup. Anyone in a position to get the note removed ? > > Cheers > > Richard > > >Quoting Metalink Note 182699.1 bde_rebuild.sql Validates and Rebuilds > Fragmentated Indexes (8.0->9.0) > > > >Index fragmentation occurs when a key value changes, and the index row > is > >deleted from one place (Leaf Block) and inserted into another. > > > > Deleted Leaf Rows are not reused. Therefore indexes whose columns are > >subject to value change must be rebuilt periodically since they become > naturally fragmentated. > > > >An index is considered to be 'fragmentated' when more than 20% of its > Leaf > Rows space is > >empty because of the implicit deletes caused by indexed columns value > changes. > > > >Fragmentated indexes degrade the performance of index range scan > operations. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Richard Foote > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Cary Millsap > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).