Difference between Cluster and Non-cluster index?
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 factors you will consider calculating the storage requirement for that view?
Define cross join in sql server joins?
Do you know what is openxml in sql server?
How to connect Azure federated root database and apply federation in entity framework?
How to concatenate two binary strings together?
Do you know the isolation level that sql server support?
What is updatable resultset?
Explain the use of containers in ssis?
What is the difference between char, varchar and nvarchar?
Can sql servers link to other servers like oracle?
What is the user of Primary key?
How to test values returned by a subquery with the in operator?
How to create nested stored procedure?
Can two tables share the same primary key?
What are unicode character string data types in ms sql server?