Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146022 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 difference between global temporary tables and local temporary tables?
Explain full-text indexing?
Explain the difference between control flow and data flow?
what is a transaction? : Sql server database administration
Describe in brief system database.
What are the advantages of using third-party tools?
What are the different type of replication in sql server?
What is single-user mode?
Are resultset updatable?
How many non clustered indexes there can be on table ?
‘Order by’ is not allowed in a view how can you sort information from a view?
What is the index requirement in SQL Azure?
Can foreign key be duplicate?
Explain few of the new features of sql server 2008 management studio
How to get @@error and @@rowcount at the same time?
