Difference between Cluster and Non-cluster index?
- 32 Answers
- 141591 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / pravin ahire
Clustered index:
1) A table can have only One clustered index
2) clustered index created on primary key only.
3) It is physical order and it is same order stored on disk.
4) clustered index is fast index than no-cluster index.
Non-clustered index:
1) A table can have only more than one non-clustered index
2) clustered index created on unique key.
3) It is logical order and it is not same order stored on disk.
4) Non-clustered index is slow index than cluster inde
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to use values from other tables in update statements in ms sql server?
What do you know about system database? : SQL Server Architecture
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Do you know what is a linked server in sql server?
What is the difference between truncate and delete commands?
Explain what are page splits? : SQL Server Architecture
What is the difference between web edition and business edition?
Do you know the isolation level that sql server support?
What is failover clustering overview?
How to create and drop temp table in sql server?
What are secondary xml indexes?
What is merge?
What are the built in functions in sql server?
Explain go command in sql server?
What is data modeling and Reterminal integrity?
