cluster tables

Creating a Cluster: Example 


CREATE CLUSTER emp_dept
   (deptno NUMBER(2));

Cluster Keys: Example 

CREATE INDEX idx_emp_dept ON CLUSTER emp_dept;

Adding Tables to a Cluster: Example 

CREATE TABLE dept_cluster
   CLUSTER  emp_dept  (deptno)
   AS SELECT * FROM dept ;

Adding Tables to a Cluster: Example 

CREATE TABLE emp_cluster
   CLUSTER  emp_dept  (deptno)
   AS SELECT * FROM emp;

Query the cluster tables;

select * from emp_cluster;
select * from dept_cluster;