CodesJava

Easy learning with example program codes

difference between clustered and nonclustered indexes in oracle sql?


Clustered indexes Non-clustered indexes
One table can have only one clustered index. One table can have multiple non-clustered index.
Clustered indexes can be read rapidly. Clustered indexes cannot read rapidly.
Clustered indexes store data physically in the table or view. Non-clustered indexes do not store data in table as it has separate structure from data row.

Related topics

Posted in SQL   
Sign Up/ Sign In
Ask a Question


Copyright © 2018 CodesJava DMCA.com Protection Status SiteMap Reference: Java Wiki