观察索引组织表（IOT）和传统堆表性能差异

--配置实验环境
EODA@PROD1> create table emp
  2  as
  3  select object_id empno,
  4  object_name	 ename,
  5  created	      hiredate,
  6  owner	      job
  7  from all_objects
  8  /

Table created.

EODA@PROD1> 
EODA@PROD1> alter table emp add constraint emp_pk primary key(empno);

Table altered.

EODA@PROD1> 
EODA@PROD1> begin
  2    dbms_stats.gather_table_stats( user, 'EMP', cascade=>true );
  3  end;
  4  /

PL/SQL procedure successfully completed.

EODA@PROD1> 
EODA@PROD1> create table heap_addresses
  2  ( empno	 references emp(empno) on delete cascade,
  3    addr_type varchar2(10),
  4    street	 varchar2(20),
  5    city	 varchar2(20),
  6    state	 varchar2(2),
  7    zip	 number,
  8    primary key (empno,addr_type)
  9  )
 10  /

Table created.

EODA@PROD1> 
EODA@PROD1> create table iot_addresses
  2    ( empno	   references emp(empno) on delete cascade,
  3  	 addr_type varchar2(10),
  4  	 street    varchar2(20),
  5  	 city	   varchar2(20),
  6  	 state	   varchar2(2),
  7  	 zip	   number,
  8  	 primary key (empno,addr_type)
  9    )
 10  ORGANIZATION INDEX
 11  /

Table created.

EODA@PROD1> insert into heap_addresses select empno, 'WORK', '123 main street', 'Washington', 'DC', 20123 from emp;

72830 rows created.

EODA@PROD1> insert into iot_addresses select empno, 'WORK', '123 main street', 'Washington', 'DC', 20123 from emp;

72830 rows created.

EODA@PROD1> insert into heap_addresses select empno, 'HOME', '123 main street', 'Washington', 'DC', 20123 from emp;

72830 rows created.

EODA@PROD1> insert into iot_addresses select empno, 'HOME', '123 main street', 'Washington', 'DC', 20123   from emp;

72830 rows created.

EODA@PROD1> insert into heap_addresses select empno, 'PREV', '123 main street', 'Washington', 'DC', 20123 from emp;

72830 rows created.

EODA@PROD1> insert into iot_addresses select empno, 'PREV', '123 main street', 'Washington', 'DC', 20123 from emp;

72830 rows created.

EODA@PROD1> insert into heap_addresses select empno, 'SCHOOL', '123 main s