Data Warehouse & Business Intelligence
Lables
Abinitio
(10)
DWH Fundamentals
(13)
Informatica
(2)
Teradata
(38)
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment