Stats collection history on a table

Database
Fan

Stats collection history on a table

Hi All

 

Could you please someone help me to find the stats collection history on a table in teradata. need to check the stats updation details on a table for the perfomance improvement. someone please help me on this.

2 REPLIES
Teradata Employee

Re: Stats collection history on a table

DBC.StatsV is the main view for looking at current statistics and the LastCollectTimestamp will tell you the last time stats have been refreshed.  There is no "history" maintained, though, unless you have a process that snapshots off the statistics information on a regular basis.

Senior Apprentice

Re: Stats collection history on a table

SHOW STATS VALUES will provide some details of previous collects in the SummaryHistory portion.