Interested to Buy Any Domain ? << Click Here >> for more details...
How Clustered Index and Non clustered index stored on SQL
server?
- 2 Answers
- 8263 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 an asp.net validator? And, mention its types.
What is connection pooling and how to enable and disable connection pooling?
What is loop in asp.net?
How can we create custom controls in asp net?
8. Why do you want to work here?
i want to implement grid view value in paypal site. so how to create this code in asp.net with C#
What is fulltrust?
Explain the page lifecycle of an asp.net mvc? : asp.net mvc
Describe Segmentation With Paging?
What is session state server?
Why we use dbms for projects? Why don’t we save any application data in separate files instead of dbms?
List the advantages and disadvantages of user control an custom control?
What are Master Pages in ASP.NET? or What is a Master Page?
What is the Intermittent crashing of application in production?
how to elimainte the similar data from the different tables
