Re: When should one rebuild an index?

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.

http://en.wikipedia.org/wiki/Data#Meaning_of_data.2C_information_and_knowledge

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

Cheers

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