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 |
is gateway for sms continue connected for sending sms.how?
Define web services in asp.net.
How many types of file extensions for razor views in ASP.Net MVC?
How many types of page.
5 Answers TCS, Verinon Technology Solutions,
what are the Custom controls in asp.net?
How can you get public key information?
How can I have a particular web page in an asp.net application which displays its own error page?
when using personlization, how do you access over setting at runtime?
What is the maximum number of classes that can be contained in one dll file?
What methods are fired during the page load? Init()
what are the State management and Its Uses
What is the use of view state?