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

How to update muliple row in single query?

824


what is isolation level at dead lock?

1939


Create and insert into temp table in sql server?

803


What are dml triggers and types of dml triggers?

749


Do you know what are acid properties?

796


Explain external key management in sql server 2008

699


Where is localdb stored?

752


What is difference between inner join and join?

762


What is acid mean in sql server?

765


How to check parameter value in stored procedure sql server?

690


What is temporary stored procedure?

733


What is the difference between for xml raw and for xml auto?

776


What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

814


What is table valued function and scalar valued functions?

729


What is database dimension? : sql server analysis services, ssas

866