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 are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

How to convert character strings into numeric values?

0 Answers  

What is user-defined function?

0 Answers  

Which table keeps the locking information?

0 Answers  

What is normalization according to you and explain its different levels?

0 Answers  

Is it important for a database administrator to understand the operating system and file access?

0 Answers  

How to achieve Paging of records in SQL SERVER?

0 Answers   Petranics Solutions,

What is use of except clause?

0 Answers  

What is nonclustered index with included columns ?

0 Answers  

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  

can you any body tell me the how to decrease the logfile

4 Answers