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.

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.

Answer / anil sharma

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

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.

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.

Answer / bhai(prakash.g)

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

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.

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.

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.

What is the default isolation level of the sql server database?

1 Answers   Ness Technologies,

What is sql server replication? : sql server replication

0 Answers  

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

How to add additional conditions in SQL?

0 Answers   Amdocs,

Whether the updations made to the views reflect the original records in the table

5 Answers   NIIT,

Can a database be shrunk with users active?

0 Answers  

What are data files?

0 Answers  

What is the guest user account in sql server? What login is it mapped to it? : sql server security

0 Answers  

What are some examples of schemas?

0 Answers  

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

How to change location of errorlog in SQL?

2 Answers   ABC, IBM,