Compare old stats to new stats for a table

UDA
Enthusiast

Compare old stats to new stats for a table

I have collected statistics on a table today. I want to compare this stats to the older stats that were there on this table before collecting today's stats.  

Is there a way to do so. I have not saved the old statistics of the table anywhere.

Little uegent. Quick reply would be appreciated.

1 REPLY
Junior Contributor

Re: Compare old stats to new stats for a table

No way, the old stats are overwritten.

The only solution would be a COPY of that table from the last backup, which also restores the stats.

Fast enough? :-)

Dieter