Svenson's Bulletin Board

[craig]

select sum(cast(INDEX_LEAF_SUM_BYTES as double)) from (
select cast(T1.NLEAF as double)*cast(T3.PAGESIZE as double) INDEX_LEAF_SUM_BYTES
,t3.pagesize as pagesize
,T1.NLEAF
FROM SYSCAT.INDEXES T1,
SYSCAT.TABLES T2,
SYSCAT.TABLESPACES T3
WHERE T1.TABNAME = T2.TABNAME
AND T1.TABSCHEMA = T2.TABSCHEMA
AND T2.INDEX_TBSPACE = T3.TBSPACE
-- AND T3.TBSPACE = 'BOFIX04'
ORDER BY 1 DESC
) a
;