Interested to Buy Any Domain ? << Click Here >> for more details...
How Clustered Index and Non clustered index stored on SQL
server?
- 2 Answers
- 8278 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
Demonstrate Render and PreRender?
Why we go for mvc instead of asp.net? : Asp.Net MVC
Explain how asp.net different from asp?
WSDL means?
How can I create master page in asp net?
What are client activated objects and server activated objects?
What is session in web technology?
Explain about ASP.NET?
Describe how to implement globalization and localization in the use interface in .net.
what is a .xap file? Explain with an example.
How do you handle server controls?
What is ispostback property?
What are sessions and cookies?
I am trying to implement sorting facility from client side code in GridView Control. So how can I fill up an Array inside client side code (using JavaScript), i want to assign my DataSet object declared and filled up on Server side(in code behind) to the array (on client side)
What is the used of "ispostback" property?
