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
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?
What are the several execute methods of ado.net?
What is meant by executenonquery?
What is the executescalar method?
What are the different methods by which we can populate a dataset?
What are disadvantages of microsoft-provided data provider classes in ado.net?
What is microsoft ado?
How to create data relations?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
What is ado.net connection?
What is microsoft ado.net?
Explain ado.net features? Benefits? Drawbacks?
What is the use of ADO.NET and XML web services?
What are good ado.net object to replace to ado recordset object.
What is the role of clr?