What is the basic difference between clustered and a non-clustered index?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

What is the basic difference between clustered and a
non-clustered index?

Question Posted / guest

9 Answers
35488 Views
Infogain, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the basic difference between clustered and a non-clustered index?..

Answer / guest

The difference is that, Clustered index is unique for any
given table and we can have only one clustered index on a
table. The leaf level of a clustered index is the actual
data and the data is resorted in case of clustered index.
Whereas in case of non-clustered index the leaf level is
actually a pointer to the data in rows so we can have as
many non-clustered indexes as we can on the db.

Is This Answer Correct ?

89 Yes

9 No

What is the basic difference between clustered and a non-clustered index?..

Answer / rajesh

I am explaining you with an example, The Telephone
Directory is a fine example of Clustered Index as data and
index are at the same page, whereas index in the back side
of the book is a fine example of non-clustered index and
non-clustered index is a fast B-tree structure as index
just points to the data page. Also only one clustered index
is possible per table and 249 non-clustered index per table.

Is This Answer Correct ?

75 Yes

10 No

What is the basic difference between clustered and a non-clustered index?..

Answer / anil sharma

clustered index one in table nad non-clustered index may be
more than one in one table.

Is This Answer Correct ?

27 Yes

10 No

What is the basic difference between clustered and a non-clustered index?..

Answer / geeta

clustered index is an index that sorts and stores the data
rows in the tables based on their key values.the data is
physically sorted in the table when clustered index is
defined on it. only one clustered index is created per
table.
In Nonclustered index contains the indx key values and the
row locators that point the storage location of the data in
a table. there can be as many as 249 nonclustered indexs
per table.

Is This Answer Correct ?

17 Yes

3 No

What is the basic difference between clustered and a non-clustered index?..

Answer / venkat reddy.ravu

**clustured index unique for a table,that reorders the data
which is physically stored in a table.Leaf node ie end
point of the clustured index contains the data pages.
**non clustured indexes logical order doesent meets the
physical order of the data in disk.leaf nodes of non
clustured indexes not contains data pages,instead contains
index rows.we can create 249 non clustured indexes on a
table.

Is This Answer Correct ?

14 Yes

2 No

What is the basic difference between clustered and a non-clustered index?..

Answer / bhai(prakash.g)

clustered index is only one clustered index per table.
non clustered index is more than one in table.

Is This Answer Correct ?

10 Yes

6 No

What is the basic difference between clustered and a non-clustered index?..

Answer / meera

Clustered index is unique for a table and 249 non-clustered
can be created.The leaf contains data and in non-clustered
the keaf node contains reference to the data.

Is This Answer Correct ?

9 Yes

5 No

What is the basic difference between clustered and a non-clustered index?..

Answer / santosh kumar

Index is Used for fast access the data.
Cluster Index is Unique in a table.One Table Contains Only
one Cluster Index but 249 Non Cluster Index is
Possible.Cluster Index is a Physical Storage and Non cluster
Index is a logical storage of the data.

Is This Answer Correct ?

7 Yes

5 No

What is the basic difference between clustered and a non-clustered index?..

Answer / s.purushothaman

The difference between a clustered index and a non-clustered index is that when you use a clustered index, the section of the table that comprises the index has its data pages linked differently from those data pages comprising a non-clustered index.

Is This Answer Correct ?

3 Yes

4 No

Post New Answer