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
Where is mysql used?
Why do we use pragma autonomous transaction?
What is identity in mysql?
How do I edit a stored procedure in mysql?
What is a scalar function?
How many sql ddl commands are supported by 'mysql'?
How can we encrypt and decrypt a data presented in a table using mysql?
What is pdo connection?
What is use of mysql?
What is relational database in mysql?
How do I show users in mysql?
Is Mysql query is case sensitive?
What is the datatype of image in mysql?
Which is better mysql or microsoft sql?
How can we convert between Unix & MySQL timestamps?