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

My experience in contacting Oracle regarding modifying of notes on MetaLink
has not been very satisfying. I did take the opportunity to voice my dissatisfaction
by using the poll at the top of the article to indicate that I would not recommend this
article to others.

Jared

Richard Foote <richard.foote_at_bigpond.com> Sent by: ml-errors_at_fatcity.com
 10/17/2003 04:29 AM
 Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Re: re Rebuilding Indexes in Oracle Apps -- was RE: RE: 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: 
  INET: Jared.Still_at_radisys.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).