Tell me difference between clustered and non clustered index in sql server

There are two Types of Index available in Sql Server:

1) Clustered Index
2) Non Clustered Index

Index is used for increase the performance application.
1) Clustered Index sequential order .primary key default clustered index. each table only once clustered index.

2) unique key default non clustered index. There 256 non clustered index in each table.

Hope this will help..............

sriram

Prabu_Spark, if this helps please login to Mark As Answer. | Alert Moderator

Clustered Index:
Clustered Index can be defined as the way on which the records of the table are physically stored. In cluster index, while inserting data itself it sorted in heap order. Only one cluster index can be creating per table.
A clustered index will be created while a primary key is created on the table.
We can create an index while creating a table and also we can create index separately.
Syntax for creating Index:

create table Table_Name 

(

Column_Name datatype constraint Constraint_Name Primary Key

)

NonClustered Index:
A NonClustered index is just a pointer to the data which points to the clustered index where the data is sorted. In NonClustered index the data are store in the form of logical order. We can create NonClustered index on 249 columns in a table.
For Example Non Clustered Index is an index of the book and clustered index is an actual page of the book.

create Nonclustered index NClx_Idx_SNo on Index_Table(Sno)

Saranya Boopathi

Prabu_Spark, if this helps please login to Mark As Answer. | Alert Moderator

Satyapriyanayak is absolutely right about Clustered and Non-clustered indexing in Sql Server.

Prabu_Spark, if this helps please login to Mark As Answer. | Alert Moderator