Index Cluster table

SQL> create cluster empdept2(deptno number(2));

   

Cluster created. => 아래 생성되는 테이블의 인덱스가 cluster에 저장됨

   

SQL> create table empx(empno number(4),dname varchar2(20),deptno number(2))

2 cluster empdept2(deptno);

   

Table created.

   

SQL> create table deptx(deptno number(2),dname varchar2(20))

2 cluster empdept2(deptno);

   

Table created.

   

SQL> select segment_name,segment_type from user_segments

2 where segment_name in('EMPX','DEPTX','EMPDEPT2');

   

SEGMENT_NAME SEGMENT_TYPE

-------------------- ------------------

EMPDEPT2 CLUSTER