VIEW: SYS.EXU81INDI

Source

View Text - Preformatted

SELECT  "IOBJID","IDOBJID","INAME","IOWNER","IOWNERID","ISPACE","ITSNO","IFILENO","IBLOCKNO","BTNAME","BTOBJID","BTOWNER","BTOWNERID","BTPROPERTY","BTCLUSTERFLAG","PROPERTY","CLUSTER$","PCTFREE$","INITRANS","MAXTRANS","BLEVEL","BITMAP","DEFLOG","TSDEFLOG","DEGREE","INSTANCES","TYPE","ROWCNT","LEAFCNT","DISTKEY","LBLKKEY","DBLKKEY","CLUFAC","PRECCNT","IFLAGS","SYSGENCONST"
        FROM    sys.exu81ind
        WHERE   sysgenconst = 0 AND                /* not sys gen constraint */
                (bitmap = 1 OR                             /* select bitmap, */
                 BITAND(property, 16) = 16 OR                 /* functional, */
                 type = 9) AND                         /* and domain indexes */
                (iownerid, btname) IN ((
                    SELECT  ownerid, name
                    FROM    sys.exu81tabi)
                  UNION (
                    SELECT  r.ownerid, r.tname
                    FROM    sys.exu9tabi ii, sys.exu8ref r
                    WHERE   r.robjid = ii.objid))   /* table included in inc */

View Text - HTML Formatted

SELECT "IOBJID"
, "IDOBJID"
, "INAME"
, "IOWNER"
, "IOWNERID"
, "ISPACE"
, "ITSNO"
, "IFILENO"
, "IBLOCKNO"
, "BTNAME"
, "BTOBJID"
, "BTOWNER"
, "BTOWNERID"
, "BTPROPERTY"
, "BTCLUSTERFLAG"
, "PROPERTY"
, "CLUSTER$"
, "PCTFREE$"
, "INITRANS"
, "MAXTRANS"
, "BLEVEL"
, "BITMAP"
, "DEFLOG"
, "TSDEFLOG"
, "DEGREE"
, "INSTANCES"
, "TYPE"
, "ROWCNT"
, "LEAFCNT"
, "DISTKEY"
, "LBLKKEY"
, "DBLKKEY"
, "CLUFAC"
, "PRECCNT"
, "IFLAGS"
, "SYSGENCONST"
FROM SYS.EXU81IND
WHERE SYSGENCONST = 0
AND /* NOT SYS GEN CONSTRAINT */ (BITMAP = 1 OR /* SELECT BITMAP
, */ BITAND(PROPERTY
, 16) = 16 OR /* FUNCTIONAL
, */ TYPE = 9)
AND /*
AND DOMAIN INDEXES */ (IOWNERID
, BTNAME) IN (( SELECT OWNERID
, NAME
FROM SYS.EXU81TABI) UNION ( SELECT R.OWNERID
, R.TNAME
FROM SYS.EXU9TABI II
, SYS.EXU8REF R
WHERE R.ROBJID = II.OBJID)) /* TABLE INCLUDED IN INC */