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

What is role-based security?

1 Answers  


What are the different Key TreeView Properties in Asp.net 2.0?

1 Answers   TCS,


What is the use of view state?

0 Answers  


Where can I get the details on migration of existing projects using various technologies to asp.net?

0 Answers  


What do you mean by View State and what is its role?

0 Answers   Wipro,


Features in ASP.NET?

2 Answers   Microsoft,


What is a Repeater Control and how does it works? and what is the diffrence b/w Gridview,datalist and repeater control?

2 Answers   USi,


Define caching.

0 Answers  


What is difference between Server.Transfer and Response.Redirect in ASP.NET?

0 Answers   Sans Pareil IT Services,


What are ASP.NET Web Forms? How is this technology different than what is available though ASP?

1 Answers   BirlaSoft,


If i have a web page, and one web user control, where in web page contains a text box, and web user control have check box, if i place a web user control in the webpage, when i check the check box, the out put should show it is checked or not. How we can do this?

1 Answers   CGI,


How to upload a file using file upload control inside the Update Panel???

2 Answers  


Categories