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

what is clustered index?why is it created?

Answer Posted / kuldeep kumawat

clustered index make physical table of the underline base table like (PhonBook,Discretionary)
and
Non clustered index is a reference table key of base table.
nonclusterd index has reference key to point a main table record
(like our not book we have index at first page and page number )
Example blow here ..
topics page no
class 20
object 30
asp.net 300
practices Example 330

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of ado.net?

872


What is a non query?

897


What is the difference between executenonquery () and executescalar ()?

904


How to bind the controls(best practice) comboboxes to the data in the dataset?

1023


How can we perform transactions in .net?

1027


What we do with the object of ado.net dataset after using it?

979


What is difference in record set and dataset?

1016


What is typed dataset ?

1132


What is the difference between an ADO.NET Dataset and an ADO Recordset?

1015


What is datasource in ado.net?

1038


What is full form of ado?

1008


What is ado.net in vb net?

895


What are typed and untyped dataset?

1069


What are the advantages of using datalist?

978


What is difference between sqldatareader and sqldataadapter?

912