What Is The Difference Between Cluster Index And Non Cluster Index In Oracle?


1 Answers

Anonymous Profile
Anonymous answered
The keyword cluster, sharing the data block from different tables or sharing the same column index for different table example emp and dept both have deptno, here we need to create a cluster index on deptno column, so the deptno cluster index help the both table to use the index.
Note:-no need to create any index saprately for both table that why we use cluster index
non-cluster not using the above statement
if I am wrong please let me know.

Answer Question