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 is data access pattern?

889


Do we use stored procedure in ADO.Net?

953


What is the default provider in ado.net?

928


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

980


What is the provider being used to access oracle database?

956


What is ado.net components?

917


What is ado.net in mvc?

893


What are the data providers used in ado.net

993


Explain how to create dynamic gridview?

931


Define connection string?

1031


What are the benefits of using ado.net?

968


How can we save all data from dataset?

955


differance between ADO vs ADO.Net?

1014


What is the difference between a datareader and a dataset?

963


What is the default Timeout for SqlCommand.CommandTimeout property?

971