All Forums Enterprise
teradatauser2 80 posts Joined 04/12
22 Apr 2012
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.

dnoeth 1921 posts Joined 11/04
22 Apr 2012

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

You must sign in to leave a comment.