Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Average Disk Space Saved By Index Reorganization in 8i or 9i

Re: Average Disk Space Saved By Index Reorganization in 8i or 9i

From: Stan <stan0074_at_removethis.yahoo.com>
Date: Mon, 05 Apr 2004 00:43:24 GMT
Message-ID: <4070ABB1.1050309@removethis.yahoo.com>


never mind. just read your earlier email in full. Will wait for it!

Stan wrote:

> Richard Foote wrote:
> 

>>
>> I've just about completed a white paper on Oracle B-Tree indexes called
>> "Oracle B-Tree Index Internals: Rebuilding The Truth" and earlier in the
>> week presented a PowerPoint version to our local user group. It basically
>> looks at the issue of index myths and actually *proves* them to be
>> incorrect. It also shows how one can investigate indexes oneself via the
>> imaginative use of Oracle treedumps, block dumps and index statistics. It
>> also gives clear guidelines on when index rebuilds may be beneficial, the
>> specific characteristics that the index needs to meet and the various
>> contributing factors that need to be considered. It covers issues that
>> are
>> simply not documented anywhere and uses example case scenarios that are
>> reproducible and can be the basis of further investigations in your own
>> specific environments.
>>
> 
> Hi Richard,
> 
> Have you published the white paper yet ? I tried google it but to no 
> avail. Can you mail it me. Thanks.
> 
> -Stan
> 
> To reply remove the obvious ones from my email address
> 


-- 
-Stan

To reply remove the obvious ones from my email address
Received on Sun Apr 04 2004 - 19:43:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US