Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 2 Yes | 0 No |
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.
Is This Answer Correct ? | 1 Yes | 0 No |
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.
Is This Answer Correct ? | 1 Yes | 0 No |
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).
Is This Answer Correct ? | 1 Yes | 0 No |
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)
Is This Answer Correct ? | 0 Yes | 0 No |
How to rename databases in ms sql server?
What is shrink log file?
How can you find out which stored procedures are recompiling?
What is nonclustered index with included columns ?
What is stored procedure in SQL..??
Do you know what is bit data type and whats the information that can be stored inside a bit column?
Explain about sql server login?
What is difference between getdate and sysdatetime in sql server 2008?
What extended events?
Can we write trigger for view?
How many types of stored procedures are there in sql server?
How to Execute an Operating System Command From Within SQL Server ?