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 Protection Status SiteMap Reference: Java Wiki