Click here to Skip to main content
16,015,755 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
Can Anyone tell me real life example on Clustered And Nonclustered Index.

Thanks.
Posted

1 solution

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 and this is usually made on the primary key. The leaf nodes of a clustered index contain the data pages.

A nonclustered 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 nonclustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.
There can be as many as 249 nonclustered index per table

Refer http://www.sql-server-performance.com/2004/index-data-structures/[^]
 
Share this answer
 
v2
Comments
ExpertITM 12-Nov-12 4:21am    
Thanks, Shanalal Kasim

Here is real life example which I want.


A telephone book is a good tangible example of a clustered index, where all the names are alphabetically arranged on each page. An example of a non-clustered index in a non-digital format would be a book’s glossary, wherein all the topics are arranged alphabetically but you have to jump from page to page to find out more about a particular topic you were searching for.
fjdiewornncalwe 13-Nov-12 9:32am    
Please add a link to reference the source of your answer. Copying and pasting someone else's information is plagarism and is not tolerated on this site. It is perfectly find that you copy/paste answers from other sources, but cite the source with a link. In this case: Source

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900