VIEW: SYS.KU$_IND_COMPART_VIEW

Source

View Text - Preformatted

select icp.obj#, value(o), icp.dataobj#, icp.bo#,
         icp.part#,
         icp.hiboundlen,
         sys.dbms_metadata_util.long2varchar(icp.hiboundlen,
                                    'SYS.INDCOMPART$',
                                    'HIBOUNDVAL',
                                    icp.rowid),
         icp.subpartcnt,
         cast(multiset(select * from ku$_ind_subpart_view isp
                       where isp.pobj_num = icp.obj#
                        order by isp.subpart_num
                      ) as ku$_ind_subpart_list_t
             ),
          icp.flags,
          -- hoist the next 2 queries up here because icp.defts# may be null
          -- and this avoids an outer join which is slooooow
          (select ts.name from ts$ ts where icp.defts# = ts.ts#),
          (select ts.blocksize from ts$ ts where icp.defts# = ts.ts#),
          icp.defpctfree, icp.definitrans,
          icp.defmaxtrans, icp.definiexts, icp.defextsize, icp.defminexts,
          icp.defmaxexts, icp.defextpct, icp.deflists, icp.defgroups,
          icp.deflogging, icp.defbufpool, to_char(icp.analyzetime,'YYYY/MM/DD HH24:MI:SS'), icp.samplesize,
          icp.rowcnt, icp.blevel, icp.leafcnt, icp.distkey, icp.lblkkey,
          icp.dblkkey, icp.clufac, icp.spare1, icp.spare2, icp.spare3,
          icp.defmaxsize
  from ku$_schemaobj_view o, indcompart$ icp
  where icp.obj# = o.obj_num

View Text - HTML Formatted

SELECT ICP.OBJ#
, VALUE(O)
, ICP.DATAOBJ#
, ICP.BO#
, ICP.PART#
, ICP.HIBOUNDLEN
, SYS.DBMS_METADATA_UTIL.LONG2VARCHAR(ICP.HIBOUNDLEN
, 'SYS.INDCOMPART$'
, 'HIBOUNDVAL'
, ICP.ROWID)
, ICP.SUBPARTCNT
, CAST(MULTISET(SELECT *
FROM KU$_IND_SUBPART_VIEW ISP
WHERE ISP.POBJ_NUM = ICP.OBJ# ORDER BY ISP.SUBPART_NUM ) AS KU$_IND_SUBPART_LIST_T )
, ICP.FLAGS
, -- HOIST THE NEXT 2 QUERIES UP HERE BECAUSE ICP.DEFTS# MAY BE NULL --
AND THIS AVOIDS AN OUTER JOIN WHICH IS SLOOOOOW (SELECT TS.NAME
FROM TS$ TS
WHERE ICP.DEFTS# = TS.TS#)
, (SELECT TS.BLOCKSIZE
FROM TS$ TS
WHERE ICP.DEFTS# = TS.TS#)
, ICP.DEFPCTFREE
, ICP.DEFINITRANS
, ICP.DEFMAXTRANS
, ICP.DEFINIEXTS
, ICP.DEFEXTSIZE
, ICP.DEFMINEXTS
, ICP.DEFMAXEXTS
, ICP.DEFEXTPCT
, ICP.DEFLISTS
, ICP.DEFGROUPS
, ICP.DEFLOGGING
, ICP.DEFBUFPOOL
, TO_CHAR(ICP.ANALYZETIME
, 'YYYY/MM/DD HH24:MI:SS')
, ICP.SAMPLESIZE
, ICP.ROWCNT
, ICP.BLEVEL
, ICP.LEAFCNT
, ICP.DISTKEY
, ICP.LBLKKEY
, ICP.DBLKKEY
, ICP.CLUFAC
, ICP.SPARE1
, ICP.SPARE2
, ICP.SPARE3
, ICP.DEFMAXSIZE
FROM KU$_SCHEMAOBJ_VIEW O
, INDCOMPART$ ICP
WHERE ICP.OBJ# = O.OBJ_NUM