How Clustered Index and Non clustered index stored on SQL
server?
- 2 Answers
- 7631 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
Why is global asax is used for?
What is asp.net ajax?
Explain the steps needed to be performed in order to create an animation in xaml?
What are sql notifications and sql invalidations?
What is dynamic web page with example?
What are the advantages of Web API?
Any disadvantages in Dataset and in reflection ?
What is the difference between mvc (model-view-controller) and mvp (model-view-presenter)? : asp.net mvc
What is the server of asp.net?
What is redirectpermanent in asp.net?
Distinguish between Server-side and Client-side code?
What are the best practices to follow to secure connection strings in an ASP.NET web application?
What is the basic purpose of the required field validator? How can you use a required field validator to check that the user changes the initial value of a text box? a listbox?
What is custom attribute?
Explain how dot net compiled code will become platform independent?
