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 |
What is the size of transaction log file?
what is DTS what are tasks available
Why would you use sql agent?
What happens when converting big values to integers?
Define primary key?
What is a virtual table in sql?
Explain error and transaction handling in sql server?
What is a transact-sql statement?
Explain forward - only cursors?
Whether the updations made to the views reflect the original records in the table
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is the query and subquery?