VIEW: SYS.KU$_IND_SUBPART_VIEW

Source

View Text - Preformatted

select isp.obj#,
         (select value(so) from ku$_schemaobj_view so
          where so.obj_num = isp.obj#),
         ts.name, ts.blocksize,
         (select value(s) from ku$_storage_view s
          where isp.ts# = s.ts_num
          AND isp.file# = s.file_num
          AND isp.block# = s.block_num),
         (select value(s) from ku$_deferred_stg_view s
          where s.obj_num = isp.obj#),
         isp.dataobj#,
         isp.pobj#,
         isp.subpart#,
         (select /*+ ordered index_rs_asc(icp i_indcompart_bopart$)
                     push_pred(tcp) push_pred(tsp) */
              tspo.subname
            from indcompart$ icp, ind$ i, tabcompart$ tcp,
                 tabsubpart$ tsp, obj$ tspo
            where icp.obj#=opart.obj# and
                  icp.bo#=iobj.obj# and
                  i.obj#=icp.bo# and
                  tcp.bo#=i.bo# and
                  tcp.part#=icp.part# and
                  tsp.pobj#=tcp.obj# and
                  tsp.subpart#=isp.subpart# and
                  tspo.obj#=tsp.obj#),
         isp.flags, isp.pctfree$, isp.initrans,
         isp.maxtrans, to_char(isp.analyzetime,'YYYY/MM/DD HH24:MI:SS'),
         isp.samplesize, isp.rowcnt,
         isp.blevel, isp.leafcnt, isp.distkey, isp.lblkkey, isp.dblkkey,
         isp.clufac, isp.spare1, isp.spare2, isp.spare3
  from indsubpart$ isp, ts$ ts, obj$ opart, obj$ iobj
  where isp.ts# = ts.ts# and
        opart.obj#=isp.pobj# and
        iobj.name=opart.name and
        iobj.type#=1 and
        iobj.owner#=opart.owner#

View Text - HTML Formatted

SELECT ISP.OBJ#
, (SELECT VALUE(SO)
FROM KU$_SCHEMAOBJ_VIEW SO
WHERE SO.OBJ_NUM = ISP.OBJ#)
, TS.NAME
, TS.BLOCKSIZE
, (SELECT VALUE(S)
FROM KU$_STORAGE_VIEW S
WHERE ISP.TS# = S.TS_NUM
AND ISP.FILE# = S.FILE_NUM
AND ISP.BLOCK# = S.BLOCK_NUM)
, (SELECT VALUE(S)
FROM KU$_DEFERRED_STG_VIEW S
WHERE S.OBJ_NUM = ISP.OBJ#)
, ISP.DATAOBJ#
, ISP.POBJ#
, ISP.SUBPART#
, (SELECT /*+ ORDERED INDEX_RS_ASC(ICP I_INDCOMPART_BOPART$) PUSH_PRED(TCP) PUSH_PRED(TSP) */ TSPO.SUBNAME
FROM INDCOMPART$ ICP
, IND$ I
, TABCOMPART$ TCP
, TABSUBPART$ TSP
, OBJ$ TSPO
WHERE ICP.OBJ#=OPART.OBJ# AND ICP.BO#=IOBJ.OBJ# AND I.OBJ#=ICP.BO# AND TCP.BO#=I.BO# AND TCP.PART#=ICP.PART# AND TSP.POBJ#=TCP.OBJ# AND TSP.SUBPART#=ISP.SUBPART# AND TSPO.OBJ#=TSP.OBJ#)
, ISP.FLAGS
, ISP.PCTFREE$
, ISP.INITRANS
, ISP.MAXTRANS
, TO_CHAR(ISP.ANALYZETIME
, 'YYYY/MM/DD HH24:MI:SS')
, ISP.SAMPLESIZE
, ISP.ROWCNT
, ISP.BLEVEL
, ISP.LEAFCNT
, ISP.DISTKEY
, ISP.LBLKKEY
, ISP.DBLKKEY
, ISP.CLUFAC
, ISP.SPARE1
, ISP.SPARE2
, ISP.SPARE3
FROM INDSUBPART$ ISP
, TS$ TS
, OBJ$ OPART
, OBJ$ IOBJ
WHERE ISP.TS# = TS.TS# AND OPART.OBJ#=ISP.POBJ# AND IOBJ.NAME=OPART.NAME AND IOBJ.TYPE#=1 AND IOBJ.OWNER#=OPART.OWNER#