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