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?

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


Please Help Members By Posting Answers For Below Questions

What are the 3 types of web?

910


what are the web form events available in asp.net?

1033


what is DLL Hell and how it is solved in .NET? please explain clearly??

2362


Explain Apache web servers ? How can you get ASP.NET running in Apache web servers - why should you do this?

981


How asynchronous call can be implemented using delegates?

990


To display data in a Repeater control which template you provide?

1034


What's the use of response.output.write()?

1260


What’s the use of “GLOBAL.ASAX” file?

1086


i develop a web application and i gave security setting i.e autherization and athentication now it work properly on my local system , now question is ,is this security setting ie autherization and athentication which i gave in web.config will it be enough strong to secure my application on internet or i have to use some 3rd party tool or software to get security .if yes --how ? if no--what is the alternate?

1957


Why is global asax is used?

1022


What is http pipeline in asp.net?

967


How is it possible for .NET to support many languages?

708


How you can manage the state of application at the server side in ASP.NET?

1060


What are the difference between overriding and overloading?

1069


Differentiate globalization and localization.

1012