How to find when the statistics was updated for an Teradata Table.

Database

How to find when the statistics was updated for an Teradata Table.

When updating Table as batch process,some table load fails to update statistics on respective Table.I want to know the SQL to get details about which are the table is not updated Statistics with lasted timestamp.

if statistics was not updated , the Report generation program takes more time.

In 'Teradata Administrtor' , i can get these details by selecting
Database->select 'List Tables & Indexes' -> Select the Particular Table -> right Click for context menu and Select Statistics menu item in the conext menu.

But i don't have access to 'Teradata Administrator' in PROD DB Server.
4 REPLIES

Re: How to find when the statistics was updated for an Teradata Table.


I got the answer for getting details about statistics on Teradata Table using SQL.

Help statistics DBName.TableName
(or)
Help stats DBName.TableName
(or)
Help stat DBName.TableName

Re: How to find when the statistics was updated for an Teradata Table.

You may also look at Dieter's Query for more efficient information on Statistics. You can find that in the archives.
IYA
N/A

Re: How to find when the statistics was updated for an Teradata Table.

Hi there, thank you for your sharing. Why there is nothing happened when I either right click or use the show statements?

Did I do anything wrong?

Re: How to find when the statistics was updated for an Teradata Table.

Where was the right click done and on which object was the show statement used?