VIEW: SYS.KU$_10_1_PIND_STATS_VIEW

Source

View Text - Preformatted

select  i.obj#,
          (select value(sov) from sys.ku$_schemaobj_view sov
           where sov.obj_num = i.obj#),
          i.bo#, 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), NULL
  from    sys.obj$ o, sys.indpart$ i
  where   i.obj# = o.obj# and
          bitand(i.flags,2) = 2                         /* index is analyzed */
UNION ALL
  select  i.obj#,
          (select value(sov) from sys.ku$_schemaobj_view sov
           where sov.obj_num = i.obj#),
          i.bo#, 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),
          cast(multiset(select value(sisv)
                        from   sys.ku$_10_1_spind_stats_view sisv
                        where  sisv.bobj_num = o.obj#)
                        as ku$_10_1_spind_stats_list_t)
  from    sys.obj$ o, sys.indcompart$ i
  where   i.obj# = o.obj# and
          bitand(i.flags,2) = 2                         /* index is analyzed */

View Text - HTML Formatted

SELECT I.OBJ#
, (SELECT VALUE(SOV)
FROM SYS.KU$_SCHEMAOBJ_VIEW SOV
WHERE SOV.OBJ_NUM = I.OBJ#)
, I.BO#
, 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)
, NULL
FROM SYS.OBJ$ O
, SYS.INDPART$ I
WHERE I.OBJ# = O.OBJ# AND BITAND(I.FLAGS
, 2) = 2 /* INDEX IS ANALYZED */ UNION ALL SELECT I.OBJ#
, (SELECT VALUE(SOV)
FROM SYS.KU$_SCHEMAOBJ_VIEW SOV
WHERE SOV.OBJ_NUM = I.OBJ#)
, I.BO#
, 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)
, CAST(MULTISET(SELECT VALUE(SISV)
FROM SYS.KU$_10_1_SPIND_STATS_VIEW SISV
WHERE SISV.BOBJ_NUM = O.OBJ#) AS KU$_10_1_SPIND_STATS_LIST_T)
FROM SYS.OBJ$ O
, SYS.INDCOMPART$ I
WHERE I.OBJ# = O.OBJ# AND BITAND(I.FLAGS
, 2) = 2 /* INDEX IS ANALYZED */