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?
- 5 Answers
- 13118 Views
- I also Faced
- E-Mail Answers
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
How to execute mysql query in php?
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
How do I download a mysql community server?
Define REGEXP?
Does mysql case matter?
Is mysql running ubuntu?
Is mysql a odbc?
Can varchar be primary key?
How to display top 10 rows in mysql?
What is the latest mysql?
How do I stop a query in mysql workbench?
What is latest version of mysql?
How do you backup a database in mysql?
What are mysql functions?
How do I disconnect mysql workbench?
