Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146963 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
What are three major types of constraints?
How to disable triggers using "disable trigger"?
What is a natural primary key?
What is the purpose of the master database?
What does nvl stand for?
What are the different types of stored procedures?
Explain about sql server login?
How do I setup a sql server database?
 Explain what is sql override for a source taLle in a mapping?
what is the maximum size of a row? : Sql server database administration
How do I delete a sql server database?
How many tables can be joined in SQL Server?
What are approximate numeric data types in ms sql server?
Define ACID properties in a Database?
State the difference between local and global temporary tables?
