Difference between Cluster and Non-cluster index?
- 32 Answers
- 138538 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / vikram kumar
The biggest difference between a clustered index and a non-
clustered index is that when you use a clustered index, the
section of the table that comprises the index has its data
pages linked differently from those data pages comprising a
non-clustered index.
In SQL Server 2005 you'll probably hear the term "heap or B-
Tree."
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of the mirroring?
What are different types of data sources?
What is Sqlpaging in SqlServer 2005 ?
Explain the benefits of user-defined functions?
What is policy management?
How is foreign key related to primary key?
How to convert numeric expression data types using the cast() function?
Where is trigger in sql server?
Do you know what are the steps to process a single select statement?
What triggers long term care?
Give main differences between "Truncate" and "Delete".
What does COMMIT command do?
What is db stored procedure?
What is a collation?
What is RMS migrations?
