There is a way out of this situation.
Write comment (0 Comments)
Performance - Tips & Tricks
Taming the wild cards - REOPT
Any DBA who has worked on solving performance issues would know about the problems parameter markers and host variables create during query optimization. If you use parameter markers, the query is not compiled every time it is executed, but you end up with a sub-optimal plan since db2 does not know the values that will be passed at query run time.
Read more...
There is a way out of this situation. |
|
|
