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.

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

0 Answers  

Explain what is it unwise to create wide clustered index keys?

0 Answers  

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

Which sql server table is used to hold the stored procedure script?

0 Answers  

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  

What are the 3 types of schema?

0 Answers  

What is a system database and what is a user database?

0 Answers  

Which command is used for user defined error messages?

0 Answers  

What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,

What is database dimension? : sql server analysis services, ssas

0 Answers  

What are ddl triggers and types of ddl trigger?

0 Answers  

What are the two authentication modes in sql server?

0 Answers