db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathey Marsden <kmarsdende...@sbcglobal.net>
Subject behavior of update statistics on empty table
Date Thu, 26 Mar 2009 17:51:34 GMT
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


Mime
View raw message