History of collect stats on particular table.

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Enthusiast

History of collect stats on particular table.

Dear friends,

 

could you please let me know, how to check history of stats for partiucular table?

 

reason for asking is, i can see some of tables in my project are collecting stats more than onetime per day and also consuimg high CPU.

 

Thanks in advance!

1 REPLY
Junior Contributor

Re: History of collect stats on particular table.

When you want to know who & when collected stats, check dbc.QryLogV for Collect Stats on this table.

 

When this is not available you get when stats were collected checking the output of a SHOW STATS VALUES, at the end there's the list of HistoryRecords which include the collect timestamps.