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:38:15 GMT
Message-ID: <4070AA7C.50400@removethis.yahoo.com>


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 Received on Sun Apr 04 2004 - 19:38:15 CDT

Original text of this message

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