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 is data access pattern?
Do we use stored procedure in ADO.Net?
What is the default provider in ado.net?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
What is the provider being used to access oracle database?
What is ado.net components?
What is ado.net in mvc?
What are the data providers used in ado.net
Explain how to create dynamic gridview?
Define connection string?
What are the benefits of using ado.net?
How can we save all data from dataset?
differance between ADO vs ADO.Net?
What is the difference between a datareader and a dataset?
What is the default Timeout for SqlCommand.CommandTimeout property?