Re: When should one rebuild an index?

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).

Cheers

        robert

-- 
remember.guy do |as, often| as.you_can - without end