Difference between Cluster and Non-cluster index?
- 32 Answers
- 138510 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
Explain foreign key in sql server?
How to attach adventureworkslt physical files to the server?
What is candidate key with example?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What is trigger explain with program?
What is transact-sql ddl trigger?
How to Insert multiple rows with a single insert statement?
How to join two tables in a single query in ms sql server?
what are the important architecture components of SSRS?
How is a full-text index updated?
What are the types of indexes?
explain different types of cursors? : Sql server database administration
what is the information that can be stored inside a bit column? : Sql server database administration
What is Extended user-defined?
What are the different types of data sources in ssrs?
