Cluster and Nocluster index in SQL Server

Question

Hi.... I know indexing in oracle but I doesn't mean cluster and noncluster index in SQl Server ? Please explain cluster and noncluster index in practically with best example ? Thanks......

Jignesh Trivedi · Answer

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.

Vineet Kumar Saini · Answer

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.......

Satyapriya Nayak · Answer

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