PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

How can you find the Table Space Size of your table across all AMP

Query 8) How can you find the Table Space Size of your table across all AMPs?
Answers)
You can find the Table Space Size of your table from this Data Dictionary Table DBC.TABLESIZE

SELECT DATABASENAME, TABLENAME, SUM(CURRENTPERM) FROM DBC.TABLESIZE WHERE DATABASENAME = ‘’ AND TABLENAME = ‘’ GROUP BY DATABASENAME , TABLENAME;

 

Add a Comment

Your email address will not be published. Required fields are marked *