Re: Coalescing Indxes on a regular basis
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: Andrew.Kerber@xxxxxxx
- Date: Tue, 10 Apr 2007 15:53:27 -0700
On 4/10/07, Kerber, Andrew W. <Andrew.Kerber@xxxxxxx> 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
Other related posts:
