Diffrance of Clustered And Nonclustered Index

Question

4.00/5 (1 vote)

See more:

SQL

SQL-Server

SQL-Server-2008

Can Anyone tell me real life example on Clustered And Nonclustered Index.

Thanks.

Posted 11-Nov-12 22:08pm

ExpertITM

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Shanalal Kasim · Accepted Answer · 2012-11-11T22:15:00

Solution 1

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/[^]

Posted 11-Nov-12 22:15pm

Shanalal Kasim

Updated 11-Nov-12 22:17pm

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