Difference between Cluster and Non-cluster index?
- 32 Answers
- 141587 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / ankit murela
cluster index:- (1)only one cluster index can be created.
(2)sort the data physically.
(3)Applied on columns which are not modifier frequencely.
(4)the leaf nodes of a cluster index contain the data pages
non-cluster index:- (1)there can 249 non cluster index per table.
(2)does not sort the data physically.
(3)Applied on columns which are modifier frequencely.
(4)The leaf nodes of a non cluster index does not contain the data pages
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Tell me what is the difference between locking and multi-versioning?
What is the main purpose of having conversation group?
What are policy management terms?
What are the disadvantages of merge replication?
Who is the owner of a schema in ms sql server?
What are the two authentication modes in sql server?
Do you know sql server 2008 introduces automatic auditing?
What is the most common type of join?
What is the maximum rows in sql server table?
How to start sql server browser service?
Explain what is sql server english query?
How many levels of sp nesting are possible?
What are the various editions of sql server 2017 that are available in the market?
What do you understand by triggers and mention the different types of it?
How to change the password of a login name in ms sql server?
