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
- 14865 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
Explain the difference between delete and truncate.
How do I declare a variable in mysql?
Can mysql and mariadb coexist?
How to set mysql variable in php?
How much does mysql cost?
What is truncate command?
What is the difference between mysql_fetch_array() and ysql_fetch_object() ?
How to make a copy values from one column to another in mysql?
How do I clear the command in mysql?
What is clob in mysql
List some comparisons operators used in mysql?
How do I connect to a database in mysql workbench?
What are mysql data types?
Can we write procedure in mysql?
What is not null in mysql?
