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.