Re: When should one rebuild an index?

From: Robert Klemme <>
Date: Sun, 28 Dec 2008 13:11:48 +0100
Message-ID: <>

On 28.12.2008 02:41, Bob Jones wrote:

> I don't know 
> what your definition of "meaningless" is here. How could something be 
> "meaningless" yet provides a specific piece of information.

It provides a bit of data, whether that is information depends on the usefulness. If you cannot do anything with it, it's just data.

>> Whatever numbers you get from ANALYZE - they are only a snapshot of the
>> current index structure. Without further information about the data,
>> change nature and frequency it is pretty useless because your perfectly
>> rebuilt index might be back to before in less time than you needed for the
>> rebuild rendering rebuilding of this index useless to harmful.
> No one is saying that cannot be the case - a special case I might add.

 From what I read in Richard's blog it is a much more common case than usually assumed.


        robert Received on Sun Dec 28 2008 - 06:11:48 CST

Original text of this message