List tables by the size of their indexes in Db2 database

Query below returns tables in a database with space used by their indexes ordered from the ones using most.


select tabschema || '.' || tabname as table,
       index_object_p_size as index_size
from sysibmadm.admintabinfo
where tabschema not like 'SYS%'
order by index_size desc;


  • table - table's schema name and name
  • index_size - space allocated for table's indexes

Sample results

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.