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
and
non-cluster not using the above statement
if I am wrong please let me know.
Thanks
Note:-no need to create any index saprately for both table that why we use cluster index
and
non-cluster not using the above statement
if I am wrong please let me know.
Thanks