Oracle的分区技术在某些条件下可以极大的提高查询的性能,所以被广泛采用。从产品上说,分区技术是Oracle企业版中独立收费的一个组件。以下是对于分区及本地索引的一个示例。
首先根据字典表创建一个测试分区表:
SQL> connect eygle/eygle
Connected.
SQL> create TABLE dbobjs
2 (OBJECT_ID NUMBER NOT NULL,
3 OBJECT_NAME varchar2(128),
4 createD DATE NOT NULL
5 )
6 PARTITION BY RANGE (createD)
7 (PARTITION dbobjs_06 VALUES LESS THAN (TO_DATE(’01/01/2007’, ’DD/MM/YYYY’)),
8 PARTITION dbobjs_07 VALUES LESS THAN (TO_DATE(’01/01/2008’, ’DD/MM/YYYY’)));
Table created.
SQL> COL segment_name for a20
SQL> COL PARTITION_NAME for a20
SQL> select segment_name, partition_name, tablespace_name
2 FROM dba_segments
3 where segment_name = ’DBOBJS’;
SEGMENT_NAME PARTITION_NAME TABLESPACE_NAME
——————– ——————– ——————————
DBOBJS DBOBJS_06 EYGLE
DBOBJS DBOB