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 to enter binary numbers in sql statements?
How do I uninstall mysql connector?
What is the difference between mysql and oracle?
How to control the max size of a heap table?
Can you tell what are various ways to create an index?
Differentiate CHAR_LENGTH and LENGTH?
What is not null in mysql?
What is blob and text in mysql?
What is indexing in mysql?
In which language it is written?
How many sql ddl commands are supported by 'mysql'?
What is the date format in mysql?
Explain the storage engines in mysql?
What are triggers in mysql?
What causes mysql too many connections?