Difference between Cluster and Non-cluster index?
- 32 Answers
- 138534 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 is usually the first word in a sql query?
can any body tell me how to know the password of current user in sql server
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is save transaction and save point?
explain different types of cursors? : Sql server database administration
What are diverse clauses that form a part of sql?
Is sql server free?
What is a fill factor?
Do you know what are the reporting services components?
Will count(column) include columns with null values in its count?
What is the difference between drop table and truncate table?
What is cursor in ms sql server?
How to find related tables in sql server?
What are scalar functions in sql?
Why should you use or avoid select * statements?
