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.exu11ind_base e$
WHERE BITAND(e$.property, 8208) != 8208 /* skip Fn Ind on MV */
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.EXU11IND_BASE E$
WHERE BITAND(E$.PROPERTY
, 8208) != 8208 /* SKIP FN IND ON MV */
|
|
|