Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147162 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 difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What is change tracking in sql server?
What is the full meaning of dml?
What are scheduled tasks in sql server?
How to attach adventureworkslt physical files to the server?
What is data mart? : sql server analysis services, ssas
Explain what is dbcc?
How to enable/disable indexes?
Which are the two editions in which SQL Azure database available?
Explain the relational database management system (rdbms)?
What is the importance of a recovery model?
Write a query for primary key constraint with identity key word?
What is an example of a foreign key?
What is the cpu pressure?
