Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146941 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / moin khan
Clustered Index
1. Only one per table
2. Faster to read than non clustered as data is
physically stored in index order
Non Clustered Index
1. Can be used many times per table
2.Quicker for insert and update operations than a
clustered index
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
Why and when do stored procedure recompile?
What are the restraints imposed on the table design by a merge replication?
Does any body please help me what question's have asked for SSRS in the interview?
How do use Having,Group by,Group function in SQL?
In what version of sql server were synonyms released?
Do you know what is openxml in sql server?
What is the contrast between sql and mysql?
How can we solve concurrency problems?
How to find which stored procedure is currently running in sql server?
Why I can not enter 0.001 second in date and time literals in ms sql server?
Does partitioning ssd reduce performance?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What is difference between oltp and olap?
Explain transaction server distributed transaction?
