也可以通过 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.
收起