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.

How do I partition a table in sql server?

0 Answers  

Which database stores information about replication?

0 Answers  

Explain what is cte (common table expression)?

0 Answers  

How many databases instances are there in sql server 2000?

0 Answers  

Explain aggregate functions?

0 Answers  

how do u do Performance tunning ?

1 Answers   Infodat Technologies, Satyam,

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

0 Answers  

Tell me what is sql profiler?

0 Answers  

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

How to get number of days in a given year?

4 Answers   ADP,