Cloud Computing

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;

 

Similar Posts

Leave a Reply

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