Lables

Friday, 18 October 2013

Query to find out biggest table in teradata

SELECT TOP 1 DATABASENAME, TABLENAME ,SUM(CURRENTPERM) FROM DBC.TABLESIZE  GROUP BY 1,2 ORDER BY 3 DESC;

No comments:

Post a Comment