Query to Identify All the tables list those are not define the statistics or stale statistics tables in teradata 14.10

General

Query to Identify All the tables list those are not define the statistics or stale statistics tables in teradata 14.10

Hi All,

Can you please some one help me to give the query to find all the tables list those are not defined the statistics or stale stats tables in teradata 14.10. I need to pull the report so that I can find the tables list and schedule the collect stats.

Thanks in advance..

Regards,

Shaik.

2 REPLIES

Re: Query to Identify All the tables list those are not define the statistics or stale statistics tables in teradata 14.10

Hi All,

Any help on the above queries?

Thanks,

Re: Query to Identify All the tables list those are not define the statistics or stale statistics tables in teradata 14.10

Hi Shaik,

Please Refer Below Query.

sel * from dbc.statsv

where TableName='TableName'

and DatabaseName='DatabaseName'

;