Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 8125 Views
- Progressive, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Does a full backup include transaction log?
What are different backups available in sql server?
Define self join in sql server joins?
Explain triggers?
What is inline variable assignment?
What is temporal data type?
What are the different types of backups avaialabe in sql server 2005?
can you instantiate a com object by using t-sql? : Sql server database administration
Explain temporary table vs table variable by using cursor alternative?
what is the system function to get the current user's user id? : Sql server database administration
How to find Duplicate Records In table?
How to connect Azure federated root database and apply federation in entity framework?
Why we need to use secondry database file? though, we can do same work using primary database file also.
Why we need sql server?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
