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.
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.