How Clustered Index and Non clustered index stored on SQL
server?
Answers were Sorted based on User's Feedback
Answer / anitha
clustered index that reorders the way in which records in
the table are physically stored.
non clustered index in which the logical order of the index
Is This Answer Correct ? | 14 Yes | 2 No |
Answer / 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 |
Please brief not about xsd,xslt & xml?
What Is ASPNET_WP.exe? What Is The Use Of It? In Which Place Inproc Session Stored ? Explain Session State ?
2 Answers Phoenix Technologies,
How to write unmanaged code and how to identify whether the code is managed /unmanaged?
If you have an application with multiple security levels though secure login and my ASP.NET web appplication is spanned across three web-servers by using round-robbin load balancing. Explain which is the best approach to maintain login-in state for the users?
What do you mean by serialize and marshalbyref?
What are custom user controls in asp.net?
Describe the difference between inline and code behind?
How will you load dynamic assembly?
What is the difference between typeof() vs gettype()?
Give me one example of Web API Routing?
What is postback pixel?
which one is faster execute reader, scalar, execute non query ?