db2数据库如何查询某个表上的每个索引大小？
每个索引的大小，单位是什么？
查看其它 1 个回答macrozeng的回答
也可以通过 admin_get_index_info 来查询具体 index 信息
举个例子
db2 => SELECT tabname, indname,iid, index_object_l_size, index_object_p_size FROM TABLE(sysproc.admin_get_index_info(\'I\',\'\',\'\')) AS t where tabname=\'EMP\';
TABNAME INDNAME IID INDEX_OBJECT_L_SIZE INDEX_OBJECT_P_SIZE
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------ -------------------- --------------------
EMP SQL151013071641000 1 256 256
EMP TT 2 256 256
EMP TT1 3 256 256
3 record(s) selected.