Difference between Cluster and Non-cluster index?
- 32 Answers
- 138633 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / div
Cluster index directly represents the physically stored
data. So their order will be the same as and when they are
populated into the table. Accessing this data will be
faster.
Non-cluster index just provides a pointer to the data.
Accessing this data will be slower when compared to the
clustered data.
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
What is tablesample?
Explain the cursor lock types?
Can foreign key be deleted?
What are the requirements on sql server network connections?
What is similarity and difference between truncate and delete in sql?
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
Difference between Logical Page and Physical Page in SSRS.
Explain nested join?
What is difference between rownum and rowid?
What are the steps you must follow to hide sql server instances?
What is the new security features added in sql server 2016? : sql server security
How to select some specific columns from a table in a query in ms sql server?
What is the dbcc command and why is it used?
What is normalization and what are the advantages of it?
Do you know what are the restrictions that views have to follow?
