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 purpose of Indexing creating? directly we can search
the reqired row with the help of query?what is the use of
indexing?

Answer Posted / d. shyamala

Indexing is helpful when you have data which is used for
retrieval rather than transactions. Indexing results in
quick retrieval of data. But Indexing should be minimized
in the database where you have lots of transactions.
Indexes are of two types Clustered and non-clustered.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

981


What are the several execute methods of ado.net?

919


What is meant by executenonquery?

929


What is the executescalar method?

1092


What are the different methods by which we can populate a dataset?

1227


What are disadvantages of microsoft-provided data provider classes in ado.net?

1022


What is microsoft ado?

993


How to create data relations?

985


How to copy the contents from one table to another table and how to delete the source table in ado.net?

1026


What is ado.net connection?

953


What is microsoft ado.net?

1134


Explain ado.net features? Benefits? Drawbacks?

1045


What is the use of ADO.NET and XML web services?

1039


What are good ado.net object to replace to ado recordset object.

1113


What is the role of clr?

941