KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a limited exposure to databases and have only used a database as an application programmer. I want to know about clustered and nonclustered indexes . I googled and I found: A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages. A nonclustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows. On Stack Overflow, I found What are the differences between a clustered and a nonclustered index? . What is the explanation for this in plain English?
Tags (comma-separated)
Save Edits
Cancel