保持Oracle数据优良性能的若干诀窍

Create table Employee ( 
EmpNo varchar2(10) primary key, 
Name varchar2(30), 
DeptNo Number(2) 
) 
Partition by range(DeptNo) 
( partition PART1 values less than (11) 
tablespace PART1_TS, 
partition PART2 values less than (21) 
tablespace PART2_TS, 
partition PART3 values less than (31) 
tablespace PART3_TS 
partition PART4 values less than (MAXvalue) 
tablespace PART4_TS 
      );

Create index Employee_DeptNo on Employee(DeptNo) local ( 
partition PART1 tablespace PART1_NDX_TS, 
partition PART2 tablespace PART2_NDX_TS, 
partition PART3 tablespace PART3_NDX_TS, 
partition PART4 tablespace PART4_NDX_TS, 
      );