RE: re Rebuilding Indexes in Oracle Apps -- was RE: RE: Separate

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: 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).