A select query over a large table runs very slow because of
the growing number of entries in that table. What different
measures could be taken to improve speed?
Answer Posted / sanjeev vishu
To improve select query speed we must use paging.
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
What does blob mean in mysql?
What are the common mysql functions?
How can you create and drop view in mysql?
Is mysql a distributed database?
What is a heap table?
What is mysql connection limit?
What are the two types of queries?
How to convert numeric values to character strings?
Do I need to pay for mysql?
What is memory table?
Are stored procedures precompiled?
How do I show users in mysql?
What is mysql used for?
How can we change the data type of a column of a table?
Is oracle better than mysql?