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

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