Row Counts of All Tables in a Database & Execute Results of Query

General
General covers Articles, Reference documentation, FAQs, Downloads and Blogs that do not belong to a specific subject area. General-purpose Articles about everything and anything
Enthusiast

Row Counts of All Tables in a Database & Execute Results of Query

 

Hi,

 

Is there a DBC/ DBQL table which maintains yesterday's row count of a table.

 

Thanks

1 REPLY
Teradata Employee

Re: Row Counts of All Tables in a Database & Execute Results of Query

Hi tera_user,

 

You can check for statistics in dbc.StatsV, but you have to be carefull about collection date.

 

You can also try in dbc.DBQLogTbl to seek for a basic 'select * from mytable' and check the NumResultRows column.