VIEW: SYS.KU$_LOBINDEX_VIEW

Source

View Text - Preformatted

select i.obj#, value(o),
         ts.name, ts.blocksize,
         (select value(s) from ku$_storage_view s
          where i.file#  = s.file_num
          and   i.block# = s.block_num
          and   i.ts#    = s.ts_num),
         (select value(s) from ku$_deferred_stg_view s
          where s.obj_num = i.obj#),
         i.dataobj#,
         i.cols, i.pctfree$,
         i.initrans, i.maxtrans, i.pctthres$, i.type#, i.flags, i.property,
         i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac,
         to_char(i.analyzetime,'YYYY/MM/DD HH24:MI:SS'), i.samplesize, i.rowcnt, i.intcols, i.degree,
         i.instances, i.trunccnt, i.spare1, i.spare2,
         i.spare3,  replace(i.spare4, chr(0)), i.spare5, to_char(i.spare6,'YYYY/MM/DD HH24:MI:SS')
   from  ku$_schemaobj_view o, ind$ i, ts$ ts
   where o.obj_num = i.obj#
         AND  i.ts# = ts.ts#

View Text - HTML Formatted

SELECT I.OBJ#
, VALUE(O)
, TS.NAME
, TS.BLOCKSIZE
, (SELECT VALUE(S)
FROM KU$_STORAGE_VIEW S
WHERE I.FILE# = S.FILE_NUM
AND I.BLOCK# = S.BLOCK_NUM
AND I.TS# = S.TS_NUM)
, (SELECT VALUE(S)
FROM KU$_DEFERRED_STG_VIEW S
WHERE S.OBJ_NUM = I.OBJ#)
, I.DATAOBJ#
, I.COLS
, I.PCTFREE$
, I.INITRANS
, I.MAXTRANS
, I.PCTTHRES$
, I.TYPE#
, I.FLAGS
, I.PROPERTY
, I.BLEVEL
, I.LEAFCNT
, I.DISTKEY
, I.LBLKKEY
, I.DBLKKEY
, I.CLUFAC
, TO_CHAR(I.ANALYZETIME
, 'YYYY/MM/DD HH24:MI:SS')
, I.SAMPLESIZE
, I.ROWCNT
, I.INTCOLS
, I.DEGREE
, I.INSTANCES
, I.TRUNCCNT
, I.SPARE1
, I.SPARE2
, I.SPARE3
, REPLACE(I.SPARE4
, CHR(0))
, I.SPARE5
, TO_CHAR(I.SPARE6
, 'YYYY/MM/DD HH24:MI:SS')
FROM KU$_SCHEMAOBJ_VIEW O
, IND$ I
, TS$ TS
WHERE O.OBJ_NUM = I.OBJ#
AND I.TS# = TS.TS#