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
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?