Saturday, January 15, 2011

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

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;

No comments:

Post a Comment