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...

Difference between Cluster and Non-cluster index?

Answer Posted / james bond

All are mad with cluster index.
they don't know wht the exact difference.
(All these are book worm.they just a ctrl+C and Ctrl+v and
nothing else)

Clustered index proper way to findd desired data like
rowndex(physical form of data) and non clustered is
mapping of these clustered index in differnt form.

(Don't try to keep as written on your mind. think it and
then use it??)

Is This Answer Correct ?    62 Yes 63 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you get second highest salary from the table?

959


How to achieve Paging of records in SQL SERVER?

1094


What is an indice?

1027


How to reaname table name without using sp_Rename in sql server..?

987


How does recursive cte works in sql server?

1006


What you can do to delete a table without the delete trigger firing?

966


How to get a list of columns in a view using the "sp_help" stored procedure?

1033


How to transfer a table from one schema to another?

994


How can I change procedure name in sql server?

1044


Explain time data type in sal server 2008?

918


If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

965


Are all views updatable ?

1148


What do you mean by tablesample?

1073


What is purpose of normalization?

943


How to defragment indexes with alter index ... Reorganize?

1077