Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146021 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
List all types of constraints in sql server?
What are the features of Embedded SQL
How fixed length strings are truncated and padded?
Benefits of Stored Procedures?
How to defragment table indexes?
Explain about system stored procedure?
How can a user-defined datatype be created?
What is microsoft sql server?
Why do we use functions?
What is autocommit mode in sql server?
How to select some specific columns from a table in a query in ms sql server?
What is the difference between a view and a stored procedure?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
How to create a view using data from another view?
Explain stored procedure?
