How Clustered Index and Non clustered index stored on SQL
server?
- 2 Answers
- 7419 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
What is a user developed application?
What are the Types of objects in ASP
Why select Web API?
Can a master page have more than one contentplaceholder?
If I have more than one version of one assemblies, then how will I use old version (how/where to specify version number?) In my application?
What is cookies in asp net?
What are the server control tags in asp.net.?
What are the namespace classes used in asp.net mvc? : asp.net mvc
What is cas?
What is the use of session in web application?
What is active web page?
What I need to create and run an asp.net application?
Is it possible to migrate visual interdev design-time controls to asp.net?
What is the compiled object?
What is viewstate in asp net with example?
