Re: When should one rebuild an index?
Date: Sun, 28 Dec 2008 13:11:48 +0100
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