Re: When should one rebuild an index?
Date: Mon, 29 Dec 2008 21:19:37 -0600
Message-ID: <5rg6l.15854$ZP4.11578@nlpi067.nbdc.sbc.com>
"DA Morgan" <damorgan_at_psoug.org> wrote in message
news:1230565383.240290_at_bubbleator.drizzle.com...
> Bob Jones wrote:
>
>> I am not surprised you reached this conclusion based on only the example
>> above.
>
> Rerun my demo and include any and all columns you wish. Then, using
> those columns and the data they contain, make your case as to how it
> constitutes sufficient information to determine an index should be
> rebuilt.
Sufficient information? Are we changing the topic again?
What a simplistic approach to tuning. If I can make a conclusion that INDEX_STATS is useless just base on a Mickey Mouse example without any other data, life would be easy. Anyone has a crystal ball to lend? Received on Mon Dec 29 2008 - 21:19:37 CST