How to get columns in collect stats

Database
Enthusiast

How to get columns in collect stats

Hi,

in my project few of the tables have collect stats on some columns...

Could you guys let me know how to get on what tables having collect stats on what fields???

1 REPLY
Senior Apprentice

Re: How to get columns in collect stats

Depends on your release:

For TD14 you get it from dbc.StatsV, before it's in various dbc views (column/index/multicolumn-StatsV) or better try my stats query to get more details:

http://developer.teradata.com/blog/dnoeth/2011/12/how-to-decode-the-binary-statistics-stored-in-dbc-...

Dieter