Difference between Cluster and Non-cluster index?
- 32 Answers
- 141616 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
How do you delete a data source?
How to create a ddl trigger using "create trigger" statements?
Explain how many types of relationship?
What are dml triggers and types of dml triggers?
What is the template in sql?
Difference between DELETE and TRUNCATE?
What is the difference between varchar and nvarchar?
What are the types of database recovery models?
What are the restrictions while creating batches in sql server?
What are the different normalization forms?
What is a hint?
What are examples of triggers?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What are different types of roles provided by ssrs?
Do you know what are acid properties of transaction?
