Re: indexes
From: Ron Crisco <ron.crisco_at_method-r.com>
Date: Tue, 18 Jan 2011 09:35:00 -0600
Message-ID: <AANLkTin-5UmDpM8FM9AmOxVN08TctyWqGDvBD0Vdm+oO_at_mail.gmail.com>
These are some articles I found to be worth reading on this subject.
Date: Tue, 18 Jan 2011 09:35:00 -0600
Message-ID: <AANLkTin-5UmDpM8FM9AmOxVN08TctyWqGDvBD0Vdm+oO_at_mail.gmail.com>
These are some articles I found to be worth reading on this subject.
“When should you rebuild an index?” by Jonathan Lewis, at http://www.dbazine.com/oracle/or-articles/jlewis14
“Oracle index internals—rebuilding the truth” by Richard Foote, which
you can download from
http://richardfoote.wordpress.com/articles-demos/
http://richardfoote.files.wordpress.com/2007/12/index-internals-rebuilding-the-truth.pdf
“Rebuilding Indexes” by Tom Kyte, at
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2913600659112
“Index Rebuild vs. Coalesce vs. Shrink Space”, by Richard Foote, at http://richardfoote.wordpress.com/2008/02/08/index-rebuild-vs-coalesce-vs-shrink-space-pigs-3-different-ones/
Ron Crisco
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 18 2011 - 09:35:00 CST