select obj#, dataobj#, bo#,
row_number() over (partition by bo# order by part#),
hiboundlen, hiboundval, subpartcnt, flags, defts#,
defpctfree, definitrans, defmaxtrans, definiexts, defextsize,
defminexts, defmaxexts, defmaxsize,
defextpct, deflists, defgroups, deflogging,
defbufpool, analyzetime, samplesize, rowcnt, blevel, leafcnt,
distkey, lblkkey, dblkkey, clufac, spare1, spare2, spare3, part#
from indcompart$
where bitand(flags, 8388608) = 0 /* filter out hidden partitions */
SELECT OBJ#
, DATAOBJ#
, BO#
,
ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY PART#)
,
HIBOUNDLEN
, HIBOUNDVAL
, SUBPARTCNT
, FLAGS
, DEFTS#
,
DEFPCTFREE
, DEFINITRANS
, DEFMAXTRANS
, DEFINIEXTS
, DEFEXTSIZE
,
DEFMINEXTS
, DEFMAXEXTS
, DEFMAXSIZE
,
DEFEXTPCT
, DEFLISTS
, DEFGROUPS
, DEFLOGGING
,
DEFBUFPOOL
, ANALYZETIME
, SAMPLESIZE
, ROWCNT
, BLEVEL
, LEAFCNT
,
DISTKEY
, LBLKKEY
, DBLKKEY
, CLUFAC
, SPARE1
, SPARE2
, SPARE3
, PART#
FROM INDCOMPART$
WHERE BITAND(FLAGS
, 8388608) = 0 /* FILTER OUT HIDDEN PARTITIONS */
|
|
|