craig Site Admin
Joined: 19 Feb 2006 Posts: 40
|
Posted: Fri Jun 23, 2006 2:01 pm Post subject: space used by index tablespaces (1st try) |
|
|
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
; |
|