Answer / ramesh.p

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.

Answer / vijaya

In Clustered Index, the data is physically sorted.
only one Clustered Index is created per table.
The data is stored in heap level of the B-tree.

In non-clustered Index, the physical order of the rows is
not same as the order of index.
there can be upto 249 non-clustered index per table.
the data is present in the random order but the logical
ordering is specified by the index.

Answer / hari

while creating primary key it will create cluster index.
while creating unique key it will create noncluster index
---cluster index it will create only one per table
---Non Cluster index it will create up to 249 per table
--cluster index physical sort the data
--Non cluster index logical sort the data.

Answer / vikas kant

Clustered index is a special type of index that reorders
the way in which the data is pysically stored in table.A
table can have just 1 clustered index.leaf nodes of a
clustered index contains the datapages.

Non clusterd index is also a special type of index in which
the logical order of the index doesnt match physical stored
rows on the disk.A table can have multiple indexes probably
(16).

Answer / anjan ghosh

when we create index then we assign a primary or unique
field , after insert of records , the results is
clustered--(field) order by
nonclustered--no order(logical order)

create table nonclusterindex(Emid int,data varchar(800))
create table clusterindex(Emid int,data varchar(800))

create unique nonclustered index nonclusterindex_emid on
nonclusterindex (Emid)

create unique clustered index clusterindex_emid on
clusterindex (Emid)

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

What is the difference between clustered index and primary key?

0 Answers  

What languages bi uses to achieve the goal?

0 Answers  

what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  

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

0 Answers  

What is ssl in sql server?

0 Answers  

What is the return type of executeupdate ()?

0 Answers  

What is nested transaction?

0 Answers  

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

whats new about truncate in sql server 2008?

0 Answers   MedSave Healthcare, Serco,

What is the difference between Triggers and Stored Procedure?

0 Answers   HCL,

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

0 Answers