Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr29.news.prodigy.com.POSTED!accdd436!not-for-mail Message-ID: <4070AA7C.50400@removethis.yahoo.com> From: Stan Organization: Home User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20021120 Netscape/7.01 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Average Disk Space Saved By Index Reorganization in 8i or 9i References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 26 NNTP-Posting-Host: 69.104.63.75 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr29.news.prodigy.com 1081125495 ST000 69.104.63.75 (Sun, 04 Apr 2004 20:38:15 EDT) NNTP-Posting-Date: Sun, 04 Apr 2004 20:38:15 EDT X-UserInfo1: Q[R_PJSCTS@UC\LY@Z^LJ^UJUSXB@DTMNHWB_EYLJZ]BGIELLNTC@AWZWDXZXQ[K\FFSKCVM@F_N_DOBWVWG__LG@VVOIPLIGX\\BU_B@\P\PFX\B[APHTWAHDCKJF^NHD[YJAZMCY_CWG[SX\Y]^KC\HSZRWSWKGAY_PC[BQ[BXAS\F\\@DMTLFZFUE@\VL Date: Mon, 05 Apr 2004 00:38:15 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:258909 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