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 |
What can we do with asp.net?
what is Master pages in asp.net? what is the advantages and disadvantages?
What is the difference between custom controls and user controls?
Explain the main function of url routing system in asp.net mvc? : asp.net mvc
How does asp page work?
How to Insert a TextBox value in to Sql database using C# coding?
17 Answers HCL, Sona, TCS,
Types of authentications in ASP.NET ?
9 Answers Accenture, Roland, Shriram,
What?s the difference between Response.Write() andResponse.Output.Write()?
What is an Interface and What is an Abstract Class?
Demonstrate Render and PreRender?
Define dll hell?
what is postback implementation?when pre-render event n init event is fired?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)