0
PARTITION BY RANGE
RANGE
HASH
LIST
RANGE
INTERVAL (
)
STORE IN (
,
)
PARTITION BY LIST
LIST
HASH
LIST
RANGE
PARTITION BY HASH
HASH
PARTITION BY SYSTEM
SYSTEM
PARTITION BY REFERENCE ("
")
REFERENCE
(
)
Y
,
(
SUBPARTITION "
"
VALUES (
)
LIST
1
VALUES LESS THAN (
)
RANGE
1
HASH
1
,
)
SUBPARTITION BY HASH
HASH
SUBPARTITION BY LIST
LIST
SUBPARTITION BY RANGE
RANGE
SUBPARTITIONS
SUBPARTITION TEMPLATE
PARTITION "
"
VALUES LESS THAN (
)
VALUES (
)
DBMS_STATS.SET_TABLE_STATS(OWNNAME=>'
',
TABNAME=>'
',
PARTNAME=>'
',
NUMROWS=>
,
NUMBLKS=>
,
AVGRLEN=>
) ;
DBMS_STATS.SET_INDEX_STATS(OWNNAME=>'
',
INDNAME=>'
',
PARTNAME=>'
',
NUMROWS=>
,
NUMLBLKS=>
,
NUMDIST=>
,
AVGLBLK=>
,
AVGDBLK=>
,
CLSTFCT=>
) ;