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