Re: When should one rebuild an index?

From: Robert Klemme <>
Date: Sat, 27 Dec 2008 16:40:01 +0100
Message-ID: <>

On 27.12.2008 15:30, Matthias Hoys wrote:

> I believe that there are still valid reasons for rebuilding indexes,

That's exactly what Richard Foote says. Please read his excellent blog (links have been posted already). It's only that the reasons and situations are far less common than usually (i.e. in the myth adhering camp) thought.

> for
> example when you remove a large amount of rows from a table, and you are
> sure that table will never grow to the same size anymore (failed batch load
> caused by programming errors etc.). Or not ?

Maybe, maybe not. You'd better check whether this index benefits from rebuilding - and whether it's worthwhile (a few wasted blocks might be ok compared to the hassle of rebuilding an index which is under heavy use).



remember.guy do |as, often| as.you_can - without end
Received on Sat Dec 27 2008 - 09:40:01 CST

Original text of this message