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

ITPub博客

2012-07-19 Using Multicolumn Partitioning Keys

最新文章