Difference between Cluster and Non-cluster index?
Answer Posted / chandu
Clustered index:
A Table have only one clustered index.
Once we defined a column with primary key constraint, sql
server automatically creates unique clustered index on that
column,
Actual rows arranged in same order as index.
Eg: Dictionary.
Non-clustered index:
Atable have 249 non clustered index.
Once we defined a column with unique key constrain , sql
server automatically create non clustered index.
Actual rows not arranged in same order as index.
Eg: Text book
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What are the dmvs?
What is the difference between dbcc indexdefrag and dbcc reindex?
What are different types of join?
Explain hostprotectionattribute in sql server 2005?
What is nonclustered index with included columns ?
Is it possible for a stored procedure to call itself or recursive stored procedure?
What is the difference between left and right outer join?
What new data source types were added in ssrs 2014?
Explain transaction server consistency?
Which tcp/ip port does sql server run on? How can it be changed?
Can you explain what is the use of custom fields in report?
Explain various data region available in ssrs with their use?
What command is used to delete a table from the database in the sql server and how?
How to create an multi-statement table-valued function?
Scalability, Availability, Integration with internet, etc.)?