Re: Coalescing Indxes on a regular basis

On 4/10/07, Kerber, Andrew W. <Andrew.Kerber_at_umb.com> wrote:
>
> Empirical evidence has shown me that on tables exceeding 20 million
> rows, even a 5% delete on the table can cause measurable degradation in
> performance that can be fixed by rebuilding the indices.
>

That really depends on the usage pattern, and data skew.

Range scans would be affected, but you would need to measure the response time before and after a rebuild to see just how great the affect would be.

Single row lookups would never know the difference.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l