Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146984 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
Do comments need to go in a special place in sql server 2005?
List some case manipulation functions in sql?
What is query processing?
How does a profiler work?
What are data resources?
Mention the 3 ways to get a count of the number of records in a table.
What is the order in which the sql query is executed?
List out a number of the wants to setup a SQL Server failover cluster?
What is indexed view?
When to use null data driven subscription?
What is collation?
What are cascading parameters in ssrs reports?
Explain where clause?
Can sql server be linked with other servers like oracle?
How dts is used to extract, transform and consolidate data?
