Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate
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: richard.foote_at_bigpond.com 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: ListGuru_at_fatcity.com (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: cary.millsap_at_hotsos.com 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: ListGuru_at_fatcity.com (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).Received on Mon Oct 20 2003 - 11:29:32 CDT
![]() |
![]() |