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
How will you fill the gridview by using datatable object at runtime?
How can we add relation between tables in a dataset?
Define different execute methods of ADO.NET command object ?
Why do we need ado.net?
What is a sqldataadapter?
What providers does Ado.net uses?
Define Execute Reader?
What is csdl entity framework?
How to add a javaScript function in a datagrid?
What is ado.net full form?
What are all components of ADO.Net data provider?
Does ado.net use odbc?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
Which keyword is used to accept variable number of parameters?
What are all the classes that are available in System.Data Namespace?