what purpose of Indexing creating? directly we can search
the reqired row with the help of query?what is the use of
indexing?
- 3 Answers
- 12353 Views
- I also Faced
- E-Mail Answers
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 to generate a single aggregate?
What is the difference between statement and preparedstatement interface?
What is ole word?
Which keyword is used to accept variable number of parameters?
Why do we serialize data?
What are the key events of sqlconnection class?
Which method is used by command class to execute SQL statements that return single value?
What are the parameters that control most of connection pooling behaviors?
Explain the difference in an abstract class and an interface?
What is executenonquery ado.net?
What are the drawbacks of using ado.net?
What is the use of sqldatareader class?
What is the purpose of using adodb?
What is execute reader in ado.net?
Explain the difference between data reader and data set?
