Few More Queries
--Check query Performance SEL TOP 5 QueryId , cast ( QUERYTEXT as varchar ( 5000 )) , ElapsedTime , MaxAMPCPUTime , AMPCPUTime , MaxAmpCpuTime * NumOfActiveAmps ,( MaxAmpCpuTime - ( 1.00 * AmpCpuTime )/ NumOfActiveAmps ) ,( 1 -( 1.00 * AmpCpuTime /( MaxAmpCpuTime * NumOfActiveAmps )))* 100 ,( MaxAmpCpuTime * NumOfActiveAmps )/( AmpCpuTime ) FROM DBC . QRYLOG WHERE MAXAMPCPUTIME > 100 ; -- Query to find stats collected about a month ago . Note : Original query picked up from Teradata Forum (As far as memory serves Original Author :Dieter Noeth ) .I have modified it a bit for my convenience . Stats modified query LOCKING ROW FOR ACCESS SEL DISTINCT 'COLLECT STATS ON ' || DATABASENAME || '.' || TABLENAME || ' ;' -- || 'COLUMN (' || COLUMNNAME ||');' FROM ( SELECT C . DATABASE