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 / jd
This question cannot be answered with the way it is formulated.
One has to run a trace to figure out why the select is slow.
it could be a lack of index, it could be bad storage
parameters, it could be that the select itself is written
poorly.
Too many problem can be described by this symptom.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I run mysql on a mac?
Explain the difference between mysql and mysql interfaces in php?
What are the differences between char and nchar?
What is acid in mysql?
What is mysql and why it is used?
How to Change a users password from unix shell.
What is insert query in mysql?
1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?
What is the default password for mysql?
How can you make a database as your current database?
Write a query to stop mysql in unix
How to filter data from a mysql database table with php?
What is the difference between truncate and delete in mysql?
Explain about reporting services of MYSQL?
Can mysql store files?