Difference between Cluster and Non-cluster index?
- 32 Answers
- 141590 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
Can multiple columns be used in sql group by clause in ms sql server?
What is the full form of dql?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
Explain cursor as data base object?
Explain system views?
How do you implement session management in SQL Server mode?
How do you check sql server is up and running?
What is nolock?
What is the report builder?
How to get a list of columns using the "sys.columns" view in ms sql server?
Do you know spatial data types - geometry and geography in sql server 2008?
What do you understand by intent locks?
What stored by the master?
What are the differences between user defined functions and stored procedures?
Tell me what is the difference between locking and multi-versioning?
