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

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

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

Jesus M. Salvo Jr.

2005-10-27, 8:21 am

Sherlock, Kevin wrote:

> Does the table have a clustered (placement) index? If not, create one and
> drop
> it. If you don't want to do that, try updating the stats on the heap
> itself to see if the negative number disappear:
>
> update statistics message_notification
_history
> message_notification
_history
>

Hi Kevin,

Thanks again for your reply.

1) So negative values in systabstats does affect the behaviour of HK GC ?

2) How is that syntax above different from simply doing:

update statistics message_notification
_history

Sponsored Links