what are the basic differences between clustered & non-clustered indexes?

what are the basic differences between clustered & non-clustered indexes?


akhil
Views: 1533 | Community Opinion: 1

Tags..  Database  Oracle  SQL SERVER  MySQL

Bookmark this page..



Ask a New Question Go to Home

Community Opinion/Answers
 
Abaid-ur-Rehman Zulfi Said..

A clustered index is a speical type of index that orders the records in the way they are stored physically on the disk. A table can have only one clustered index. The leaf nodes of clustered index contain data pages.

A non-clustered index is a specail type of index in which logical order of records don't match with physical order of records. A table can have multiple non-clustered indexes. The leaf nodes contain index rows.






Register or Login to Post Your Opinion