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 / dinesh goyal
By using LIMIT we can improve speed.
| Is This Answer Correct ? | 5 Yes | 10 No |
Post New Answer View All Answers
What does do in mysql?
What are the 'mysql' command line arguments?
What is the limitation of mysql?
What is the data type for file in mysql?
How do I start and stop mysql on windows?
Can we rollback truncate in mysql?
What are federated tables?
What is pdo :: fetch_assoc?
Explain timestamp?
How to concatenate two character strings?
How to enable or disable a row of a table using MySQL in struts?
How to insert html code into mysql database using php?
What is blob in mysql?
What is pdo in mysql?
What is the current root password of mysql?