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
- 15182 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
