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 triggers and its types?
What do you understand by a view? What does the with check option clause for a view do?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What are the different types of lock modes in sql server 2000?
What is onf in normalization form?
How to encrypt Strored Procedure in SQL SERVER?
Explain indexed views?
Why should one not prefix user stored procedures with ‘sp_’?
Will count(column) include columns with null values in its count?
What command must you use to include the not null constraint after a table has already been created?
What is a subquery in a select query statement in ms sql server?
What will be the maximum number of index per table?
What is data block and how to define data block size?
Can you name some of the dml commands in sql?
What is cte (common table expression)?