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

How do I send an email message from my ASP.NET page?

0 Answers  


What is a web farm?

0 Answers  


4. How do you plan to achieve these goals?

7 Answers   Burger King, Latest, Swatz Oils,


What are the ways to sending the data in ASP.NET page?

0 Answers  


When we do partial refresh of a page using update panel how server knows it(which event occurs?)

2 Answers  


what is the requirement that .Net web services can access the java application?

6 Answers   iSoft,


What is the difference between WindowsDefaultLocation and WindowsDefaultBounds?

0 Answers   BirlaSoft,


Explain the difference between overriding and overloading?

0 Answers  


Give a few examples of page life cycle events.

0 Answers   Accenture,


what does membership class provide?

1 Answers  


How do we get only edited/deleted/inserted records from a Dataset?

1 Answers   Syntax Softtech,


what is use to destroy an object? illustrate.

2 Answers   Patni,


Categories