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 do I disconnect mysql workbench?
Can we write pl sql mysql?
What is the datatype of image in mysql?
How do I delete a row in mysql?
what is database white box testing? : Mysql dba
How do I setup mysql?
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
What is InnoDB?
What is delimiter in mysql trigger?
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?
Why we use mysql database?
What are the disadvantages of stored procedures?
Define REGEXP?
How to create trigger in mysql phpmyadmin?