Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT CHAR(TABNAME, 10) AS TABLE, DATA_OBJECT_L_SIZE / 1024 AS ‘DATA SIZE [MB]’, INDEX_OBJECT_L_SIZE / 1024 AS ‘INDEX SIZE [MB]’ FROM SYSIBMADM.ADMINTABINFO WHERE TABSCHEMA = ‘TPCH’ ORDER BY DATA_OBJECT_L_SIZE DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement