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 types of indexes? : Sql server database administration
How to override dml statements with triggers?
What is the Disadvantage of indexed sequential file.
Explain syntax for dropping triggers?
what is a live lock? : Sql server database administration
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
Define left outer join in sql server joins?
Explain what are sparse columns?
List the various tools available for performance tuning?
Do you know what is a trace frag? Where do we use it?
How many null values we can have in a unique key field in sql server?
What are the differences between clustered and non-clustered index?
How to enable/disable indexes?
What is the new security features added in sql server 2016? : sql server security
Explain differentiate between a having clause and a where clause?