Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 148113 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
When a primary key constraint is included in a table, what other constraints does this imply?
Where in ms sql server is ’100’ equal to ‘0’?
What does <> symbol mean?
What is oltp (online transaction processing)?
How do you make a trace?
How can I know what locks are running on which resource?
What are the types of database recovery models?
What are the fixed server level roles? : sql server security
What are the security related catalog views? : sql server security
Explain boyce and codd normal form(bcnf)?
How to concatenate two strings in SQL Server.
What are the properties of sub-query?
Do you know nested transaction?
Explain candidate key, alternate key, and composite key?
What is a trigger and types of a trigger?
