select i.obj#,
(select value(sov) from sys.ku$_schemaobj_view sov
where sov.obj_num = i.obj#),
i.pobj#, i.rowcnt, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey,
i.clufac, i.blevel,
decode(bitand(i.flags, 24), 24, 3, 16, 2, 8, 1, 0),
o.flags,
(select value(icsv) from sys.ku$_ind_cache_stats_view icsv
where i.obj# = icsv.obj_num)
from sys.obj$ o, sys.indsubpart$ i
where i.obj# = o.obj# and
bitand(i.flags,2) = 2 /* index is analyzed */
SELECT I.OBJ#
,
(SELECT VALUE(SOV)
FROM SYS.KU$_SCHEMAOBJ_VIEW SOV
WHERE SOV.OBJ_NUM = I.OBJ#)
,
I.POBJ#
, I.ROWCNT
, I.LEAFCNT
, I.DISTKEY
, I.LBLKKEY
, I.DBLKKEY
,
I.CLUFAC
, I.BLEVEL
,
DECODE(BITAND(I.FLAGS
, 24)
, 24
, 3
, 16
, 2
, 8
, 1
, 0)
,
O.FLAGS
,
(SELECT VALUE(ICSV)
FROM SYS.KU$_IND_CACHE_STATS_VIEW ICSV
WHERE I.OBJ# = ICSV.OBJ_NUM)
FROM SYS.OBJ$ O
, SYS.INDSUBPART$ I
WHERE I.OBJ# = O.OBJ# AND
BITAND(I.FLAGS
, 2) = 2 /* INDEX IS ANALYZED */
|
|
|