|
Suppose I have a program which uses a dynamic SQL and it has been performing ...
DB2 ( IBM Database 2 ) Interview Questions
(Continued from previous question...)
Suppose I have a program which uses a dynamic SQL and it has been performing ...
Q: Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that performance has deteriorated. What happened?
AN:
There may be one of the following reasons:
probably RUN STATS is not done and the program is using a wrong index due to incorrect stats.
probably RUN STATS is done and optimizer has chosen a wrong access path based on the latest statistics.
(Continued on next question...)
Other Interview Questions
| 