Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Thursday, 14 April 2016

How to know Teradata Table size

SELECT TABLENAME, SUM((CURRENTPERM)/1024**3)
FROM DBC.TABLESIZE
WHERE DATABASENAME = 'YOUR_DB_NAME'
AND TABLENAME = 'YOUR_TABLE_NAME'
GROUP BY TABLENAME;


No comments:

Post a Comment

Please provide your feedback in the comments section above. Please don't forget to follow.