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

Please follow and like us:
Posted in SQL   


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