Advertisement
Guest User

Untitled

a guest
Oct 19th, 2019
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. 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