Interested to Buy Any Domain ? << Click Here >> for more details...
Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 8794 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
System variable and temporary variables
What is normalization and what are the advantages of it?
How can I add Reporting Services reports to my application?
What are some examples of schemas?
What happens if an integer is too big for int date type?
Do you know what is blocking?
What are data regions?
How much space does sql server 2016 take?
How to get a list all databases on the sql server?
What is resource db in sql server?
What is partition index in sql server?
What is a trigger? Why we need it?
What happens if ntwdblib.dll is missing on your machine?
Do you know sql server 2008 introduces automatic auditing?
Does a server store data?
