Difference between Cluster and Non-cluster index?
- 32 Answers
- 138527 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 the partitioning method?
Why and when do stored procedure recompile?
How do I create a stored procedure in dbml?
Can sql servers linked to other servers like oracle?
What is a periodical index?
How to provide values to user defined function parameters?
What is spatial and temporal data?
What are views in ms sql server?
How to create a Master database in SQL server ?
Tell me what is difference between clustered and non clustered index?
What were the latest updates to SQL Azure service?
What is the difference between lock, block and deadlock? : sql server database administration
What are the advantages of using cte?
Write SQL queries on Self Join and Inner Join.
Explain a join?
