Cluster and Nocluster index in SQL Server

hi,

Please refer below link,

http://msdn.microsoft.com/en-us/library/aa933130%28v=sql.80%29.aspx
http://www.codeproject.com/Articles/173275/Clustered-and-Non-Clustered-Index-in-SQL-2005

it has good example to use of index.

Hi Nayak Ji....

I have already read this concept but I want to know real life example of cluster and non cluster practically example ?








Thanks.......

Hi Vineet,

Index in sql is created on existing tables to retrieve the rows quickly.

There are 2 Types of Indexes

Clustered Index: A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages. Clustered index is physically stored a table can have 1 clustered index

Non-Clustered Index: A non-Clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non-Clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows. On clustered index is logically stored a table can have 249 non Clustered index


Please refer the below links

http://www.c-sharpcorner.com/uploadfile/nipuntomar/clustered-index-and-non-clustered-index-in-sql-server/default.aspx

http://www.c-sharpcorner.com/uploadfile/6897bc/clustered-and-non-clustered-index-in-sql-2005/default.aspx


Thanks