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?
- 3 Answers
- 13857 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
What provider ado.net use by default? Explain the role of data provider in ado.net?
What is difference between connected and disconnected architecture in ado.net?
What is a non query?
Why is stored procedure used in ado.net?
Difference between sqlcommand and sqlcommandbuilder?
how Sequence to connect and retrieve data from database using dataset?
What are the 3 major types of connection objects in ado.net?
What is the role of data provider in ado.net?
How do you update a dataset in ado.net and how do you update database through dataset?
Give an example that shows how to execute a stored procedure in ado.net?
Why do we serialize data?
Can datareader hold data from multiple tables?
How to enable and disable connection pooling?
What is meant by executenonquery?
Is bulk insert faster than insert?
