Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147227 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / pravin ahire
Clustered index:
1) A table can have only One clustered index
2) clustered index created on primary key only.
3) It is physical order and it is same order stored on disk.
4) clustered index is fast index than no-cluster index.
Non-clustered index:
1) A table can have only more than one non-clustered index
2) clustered index created on unique key.
3) It is logical order and it is not same order stored on disk.
4) Non-clustered index is slow index than cluster inde
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What do you mean by an execution plan?
What are the events recorded in a transaction log?
What is database white box testing?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is the recovery model?
What is a fan-out query in SQL Azure?
What is the latest version of microsoft sql server?
What is the most common type of join?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is transaction server auto commit?
what are the reporting service components in SSRS?
How do you create a data source?
Explain system views?
Explain log shipping?
Tell me what is normalization? Explain different forms of normalization?
