http://www.itpub.net/thread-1637063-1-1.html
SQL> create table test
2 (
3 a number,
4 b number,
5 c number)
6 PARTITION BY RANGE (a,b)
7 ( PARTITION "WRH$_LATCH_1166965666_361" VALUES LESS THAN (1166965666, 384),
8 PARTITION "WRH$_LATCH_1166965666_384" VALUES LESS THAN (1266965666, 412),
9 PARTITION "WRH$_LATCH_1166965666_412" VALUES LESS THAN (1366965666, MAXVALUE),
10 PARTITION "WRH$_LATCH_MXDB_MXSN" VALUES LESS THAN (MAXVALUE, MAXVALUE)
11 );
Table created.
SQL> insert into test values(1200000000,500,1);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from test partition(WRH$_LATCH_1166965666_384);
A B C
---------- ---------- ----------
1200000000 500 1
多键值分区,首先根据第一个列的值进行判断,如果根据第一个列就可以判断,那么不需要比较第二个列。
只有第一个列的值与分区上限值相同,才会比较第二个列。
http://docs.oracle.com/cd/E11882_01/server.112/e25523/part_admin001.htm#VLDBG00301
SQL> create table test
2 (
3 a number,
4 b number,
5 c number)
6 PARTITION BY RANGE (a,b)
7 ( PARTITION "WRH$_LATCH_1166965666_361" VALUES LESS THAN (1166965666, 384),
8 PARTITION "WRH$_LATCH_1166965666_384" VALUES LESS THAN (1266965666, 412),
9 PARTITION "WRH$_LATCH_1166965666_412" VALUES LESS THAN (1366965666, MAXVALUE),
10 PARTITION "WRH$_LATCH_MXDB_MXSN" VALUES LESS THAN (MAXVALUE, MAXVALUE)
11 );
Table created.
SQL> insert into test values(1200000000,500,1);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from test partition(WRH$_LATCH_1166965666_384);
A B C
---------- ---------- ----------
1200000000 500 1
多键值分区,首先根据第一个列的值进行判断,如果根据第一个列就可以判断,那么不需要比较第二个列。
只有第一个列的值与分区上限值相同,才会比较第二个列。
http://docs.oracle.com/cd/E11882_01/server.112/e25523/part_admin001.htm#VLDBG00301
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24383181/viewspace-735986/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24383181/viewspace-735986/