Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How Clustered Index and Non clustered index stored on SQL
server?

Answers were Sorted based on User's Feedback



How Clustered Index and Non clustered index stored on SQL server?..

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

How Clustered Index and Non clustered index stored on SQL server?..

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

Post New Answer

More ASP.NET Interview Questions

hi i have a problem regarding to datagrid in aspdotnet.i have a datagrid in my application.i have to place add,edit,delete buttons or links what ever it may be. now the problem is if i click on add button then the page has to redirected to another form called "xyz.aspx" and if i click on edit button the page has to redirected to another form called "abc.aspx".i am phasing the problem that if where ever i click on the datagrid the cursor goes to gv1_SelectedIndexChanged event.please tell me the solution about the code.

4 Answers   Lambent,


ASP.NET uses event driven programming model.Justify.

2 Answers  


How can we inherit a static member?

0 Answers  


what are the sitemap providers in Asp.net 2.0?

2 Answers  


What is the difference between ASP.NET Webforms and ASP.NET MVC?

0 Answers  


Exception handling

2 Answers   Syntel,


What is web api and why to use it?

0 Answers  


What is a query string in a url?

0 Answers  


difference between Trace and Debug ?

2 Answers   Accenture, HCL, Patni,


Difference between ADO.Net 1.1 and ADO.Net 2.0 ?

1 Answers   Value Labs,


What is session id in web application?

0 Answers  


How to Open any web page by clicking any Any ASPControl like (Checkbox,radio button or Button) without calling its event and without going to Siverside code?

5 Answers   LG Soft,


Categories