Optimizing Storage Structures - Oracle Database 11gR2 Performance Tuning - page 104

6. In the next screenshot, we can see the results of the previous statement:

7. Verify the execution plan for the clustered table:

SET AUTOT TRACE EXP
SELECT * FROM CL_EMPLOYEES WHERE DEPARTMENT_ID = 20;

8. In the next screenshot, we can see the results of the query against the

clustered table:

9. Drop the cluster and the related tables:

DROP CLUSTER EMP_DEPT_CLUSTER INCLUDING TABLES;