This is kind of an edge case, but I wonder, what should be the behavior of update statistics on an empty table if it had previously created statistics.

The current behavior seems to be that it leaves the old statistics values in sys.sysstatistics. Is that correct? It seems to me it should drop the statistics information in this case.

Thanks

Kathey

Reply via email to