ASE Database forum - Re: Non-clustered indexes on DOL tables and update operations ( Re: Bug with a datetime of '1753-01

Author

Re: Non-clustered indexes on DOL tables and update operations ( Re: Bug with a datetime of '1753-01

Sherlock, Kevin

2005-10-27, 8:21 am

See below:

"Jesus M. Salvo Jr." <noone@noone.org> wrote in message
news:435589f7@forums
-1-dub...
> Sherlock, Kevin wrote:
>
>
> Hi Kevin,
>
> Thanks again for your reply.
>
>
> 1) So negative values in systabstats does affect the behaviour of HK GC ?

I don't know, but you're mixing threads here. I was only addressing the
possible reasons for so many IO's when searching on "1753-01-01 00:00:00".

> 2) How is that syntax above different from simply doing:
>
> update statistics message_notification
_history

By specifying the heap as the "index", you only generate statistics for the heap
and not all of the other indexes. So, it runs faster, and it specifically asks
for stats on the heap table (index 0 if you will). I only suggested that syntax
so your updated stats would run faster. The above syntax should give you the
same results for the heap (table), but it also generates histograms and index
stats for the rest of the indexes.

Sponsored Links