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
How large can a mysql database become?
What are all the Common SQL Function?
How to dump a table to a file with 'mysqldump'?
How does triggers work in mysql?
What is regex in mysql?
How do I change directories in mysql?
Is mysql still relevant?
Is mysql query case sensitive?
What language is used in mysql?
Do I need to pay for mysql?
Why do you think it is advised to not to use guid and character columns as clustered index arrays?
What are the steps required to view your mysql database?
What is mysql cursor?
How to insert dynamic values in mysql using php?
How do I restore a mysql database dump file in linux?