How to see Information In Data Dictionary in teradata after stats collections

Teradata Applications
Enthusiast

How to see Information In Data Dictionary in teradata after stats collections

There are 3 locations. DBC.ColumnStats, DBC.IndexStats, and DBC.MultiColumnStats where the information for the stats used to get stored.i'm giving the below query to find that info regarding no of rows in a table or average row size  etc.

SEL* FROM DBC.COLUMNSTATS WHERE TABLENAME LIKE'%INFA_SOURCE12%'

This Query is not working for me .please correct me if i'm going wrong somewhere

Tags (1)
1 REPLY
Teradata Employee

Re: How to see Information In Data Dictionary in teradata after stats collections

What database version? Always use the "V" suffix version of DBC views (since TD12).

When you say it's "not working", do you mean that the query runs but returns no rows?