VIEW: SYS.KU$_IND_PART_VIEW

Source

View Text - Preformatted

select ip.obj#,
         (select value(so) from ku$_schemaobj_view so
          where so.obj_num = ip.obj#),
         ts.name, ts.blocksize,
         (select value(s) from ku$_deferred_stg_view s
          where s.obj_num = ip.obj#),
         (select value(s) from ku$_storage_view s
          where ip.ts# = s.ts_num
          AND ip.file# = s.file_num
          AND ip.block# = s.block_num),
         ip.dataobj#, ip.bo#,
         ip.part#,
         (select tpo.subname
           from obj$ tpo, tabpart$ tp, ind$ i
           where i.obj#=ip.bo# and
                 tp.bo#=i.bo# and
                 tp.part#=ip.part# and
                 tpo.obj#=tp.obj#),
         ip.hiboundlen,
         sys.dbms_metadata_util.long2varchar(ip.hiboundlen,
                                    'SYS.INDPART$',
                                    'HIBOUNDVAL',
                                     ip.rowid),
         ip.flags, ip.pctfree$, ip.pctthres$,
         ip.initrans, ip.maxtrans, to_char(ip.analyzetime,'YYYY/MM/DD HH24:MI:SS'), ip.samplesize,
         ip.rowcnt, ip.blevel, ip.leafcnt, ip.distkey, ip.lblkkey,
         ip.dblkkey, ip.clufac, ip.spare1, ip.spare2, ip.spare3,
         ip.inclcol,
         (select decode(bitand(ipp.flags, 1), 1, ipp.parameters, null)
            from indpart_param$ ipp
          where ipp.obj#=ip.obj#)
  from  indpart$ ip, ts$ ts
  where ts.ts#=ip.ts#

View Text - HTML Formatted

SELECT IP.OBJ#
, (SELECT VALUE(SO)
FROM KU$_SCHEMAOBJ_VIEW SO
WHERE SO.OBJ_NUM = IP.OBJ#)
, TS.NAME
, TS.BLOCKSIZE
, (SELECT VALUE(S)
FROM KU$_DEFERRED_STG_VIEW S
WHERE S.OBJ_NUM = IP.OBJ#)
, (SELECT VALUE(S)
FROM KU$_STORAGE_VIEW S
WHERE IP.TS# = S.TS_NUM
AND IP.FILE# = S.FILE_NUM
AND IP.BLOCK# = S.BLOCK_NUM)
, IP.DATAOBJ#
, IP.BO#
, IP.PART#
, (SELECT TPO.SUBNAME
FROM OBJ$ TPO
, TABPART$ TP
, IND$ I
WHERE I.OBJ#=IP.BO# AND TP.BO#=I.BO# AND TP.PART#=IP.PART# AND TPO.OBJ#=TP.OBJ#)
, IP.HIBOUNDLEN
, SYS.DBMS_METADATA_UTIL.LONG2VARCHAR(IP.HIBOUNDLEN
, 'SYS.INDPART$'
, 'HIBOUNDVAL'
, IP.ROWID)
, IP.FLAGS
, IP.PCTFREE$
, IP.PCTTHRES$
, IP.INITRANS
, IP.MAXTRANS
, TO_CHAR(IP.ANALYZETIME
, 'YYYY/MM/DD HH24:MI:SS')
, IP.SAMPLESIZE
, IP.ROWCNT
, IP.BLEVEL
, IP.LEAFCNT
, IP.DISTKEY
, IP.LBLKKEY
, IP.DBLKKEY
, IP.CLUFAC
, IP.SPARE1
, IP.SPARE2
, IP.SPARE3
, IP.INCLCOL
, (SELECT DECODE(BITAND(IPP.FLAGS
, 1)
, 1
, IPP.PARAMETERS
, NULL)
FROM INDPART_PARAM$ IPP
WHERE IPP.OBJ#=IP.OBJ#)
FROM INDPART$ IP
, TS$ TS
WHERE TS.TS#=IP.TS#