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 is the difference between coalesce() & isnull()?
What are the Advantages of using CTE in sql server?
How do I start sql server agent automatically?
What is the library index called?
What is sql server replication? : sql server replication
What are distinctive joins find as a part of sql?
What is data compression?
How to search for a string in all stored procedure in sql server?
What are subqueries in sql server?
What is an indice?
What is lock escalation and what is its purpose?
How to update a field in SQL after ALTERING a row?
How do you debug a procedure in sql server?
How do I create an extended event in sql server?
What is explicit cursors?