How to get columns in collect stats

Database

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
N/A

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