How Clustered Index and Non clustered index stored on SQL
server?
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 session object? Describe in detail.
Is oauth for authentication or authorization?
Explain the difference between server.transfer and response.redirect? Why would I choose one over the other?
What is difference between web config and global asax?
Explain the difference between debug.write and trace.write? When should each be used?
Why and where this web.config file is used?
What does asp.net stand for?
Is asp.net free?
Diff between web user control and web custom control?
What is the difference between ASP.NET Webforms and ASP.NET MVC?
How will you load dynamic assembly? How will create assesblies at run time?
What is user control in asp.net?
What are the different types of validation controls in asp.net?
How you will improve web application performance?
What are the 3 types of web?