How Clustered Index and Non clustered index stored on SQL
server?
- 2 Answers
- 7442 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / answerme
Clustered Index are always stored on disk in a certain
order i.e, the data on disk may well be stored in order of
the Primary Key. So the data retreival is faster, when
queried based on Primary key.
non Clustered indexes are all the other indexes on a table,
that do not dictate the order that records are stored on
disk.A non Clustered index stores all the fields that
comprise the index, plus a link to the actual full record
on disk. This link is the primary key (clustered index), so
in fact a non clustered index contains all the columns that
you specify for them plus the clustered index columns too.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How much is the pay-for-use service if I chose not to use microsoft-sponsored advertising?
What is the difference between custom controls and user controls?
How does session work?
Can I recieve both html markup for page and code in the asp.net web page's source code portion in the web browser?
What are the advantages of passport authentication?
If Instancing = Single use for ActiveX Exe, how will this be executed if there are 2 consecutive client requests ?
How to disable disable browser's Back button in asp.net (JavaScript)?
How long does an http session last?
Explain Optimization technique description?
Which control has default post back is enabled(true)?
How to fetch a data from one table to another table in asp.net ?
how can we create wcf in asp.net and how can we cll that in to asp.net application?plsss tel me each step clearly
How will you do Redo and Undo in a TextControl?
What is css and what is it used for?
Disable Mouse right click on web page in asp.net?
