Difference between Cluster and Non-cluster index?
- 32 Answers
- 141867 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
Can we hide the definition of a stored procedure from a use?
How to create a simple stored procedure in ms sql server?
What do you understand by the data quality services in sql server?
You want to implement the one-to-many relationship while designing tables. How would you do it?
Explain the commands in sql server?
What is transaction server auto commit?
What are the types of indexing?
What are group functions in query statements in ms sql server?
Explain query editor regions
Tell me what is fill factor?
Explain the properties of sub-query in sql server?
What is field with example?
Explain the ways to controlling cursor behavior?
Why use “nolock” in sql server?
Is the primary key column of a table an index in ms sql server?
