Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14675 Views
- I also Faced
- E-Mail Answers
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 to drop an existing index in mysql?
What is the use of mysql workbench?
How do you create a table in mysql workbench?
How can you handle the –secure-file-priv in mysql?
What are the advantages of MySQL when compared with Oracle?
How to enter Characters as HEX Numbers?
How to Set a root password if there is on root password.
What do you need to connect php to mysql?
What are the critical issues you have resolved in your company
What is a mysql model?
How to return query output in xml format?
What is view? How can you create and drop view in mysql?
How do I start mysql in linux?
How do I install and use mysql?
What is mysql_connect?
