select obj#, dataobj#, bo#,
row_number() over (partition by bo# order by part#),
hiboundlen, hiboundval, flags, ts#, file#, block#,
pctfree$, pctthres$, initrans, maxtrans, analyzetime, samplesize,
rowcnt, blevel, leafcnt, distkey, lblkkey, dblkkey, clufac, spare1,
spare2, spare3, inclcol, part#
from indpart$
where bitand(flags, 8388608) = 0 /* filter out hidden partitions */
SELECT OBJ#
, DATAOBJ#
, BO#
,
ROW_NUMBER() OVER (PARTITION BY BO# ORDER BY PART#)
,
HIBOUNDLEN
, HIBOUNDVAL
, FLAGS
, TS#
, FILE#
, BLOCK#
,
PCTFREE$
, PCTTHRES$
, INITRANS
, MAXTRANS
, ANALYZETIME
, SAMPLESIZE
,
ROWCNT
, BLEVEL
, LEAFCNT
, DISTKEY
, LBLKKEY
, DBLKKEY
, CLUFAC
, SPARE1
,
SPARE2
, SPARE3
, INCLCOL
, PART#
FROM INDPART$
WHERE BITAND(FLAGS
, 8388608) = 0 /* FILTER OUT HIDDEN PARTITIONS */
|
|
|