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


Please Help Members By Posting Answers For Below Questions

What is triggers and its types?

766


What do you understand by a view? What does the with check option clause for a view do?

813


How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

825


What are the different types of lock modes in sql server 2000?

676


What is onf in normalization form?

818


How to encrypt Strored Procedure in SQL SERVER?

830


Explain indexed views?

768


Why should one not prefix user stored procedures with ‘sp_’?

846


Will count(column) include columns with null values in its count?

886


What command must you use to include the not null constraint after a table has already been created?

796


What is a subquery in a select query statement in ms sql server?

852


What will be the maximum number of index per table?

756


What is data block and how to define data block size?

811


Can you name some of the dml commands in sql?

800


What is cte (common table expression)?

803