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

How will you fill the gridview by using datatable object at runtime?

1065


How can we add relation between tables in a dataset?

1000


Define different execute methods of ADO.NET command object ?

1107


Why do we need ado.net?

974


What is a sqldataadapter?

998


What providers does Ado.net uses?

1022


Define Execute Reader?

1074


What is csdl entity framework?

1026


How to add a javaScript function in a datagrid?

1138


What is ado.net full form?

995


What are all components of ADO.Net data provider?

1063


Does ado.net use odbc?

959


Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

1021


Which keyword is used to accept variable number of parameters?

1128


What are all the classes that are available in System.Data Namespace?

1015