2012-07-19 Using Multicolumn Partitioning Keys

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博客 ” ，链接：http://blog.itpub.net/24383181/viewspace-735986/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24383181/viewspace-735986/