There is a way out of this situation.
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.
Write comment (0 Comments)
|
|
|
|
|
More Articles...
|
|
|
|
|
| Page 1 of 4 |
| Re:Upgrading to db2 v9.5 on SAP ERP (Netweaver) | 2008/08/25 14:31 by jersing | |
| Upgrading to db2 v9.5 on SAP ERP (Netweaver) | 2008/08/25 14:12 by zero | |
| Re:Strange issues with remote shell (rsh) | 2008/08/22 16:37 by zero | |
| Strange issues with remote shell (rsh) | 2008/08/22 14:03 by jersing | |
| Re:Welcome to the Forums | 2008/08/22 13:58 by jersing | |
| Re:SQL5043N | 2008/07/21 15:21 by db2admin | |
| Re:SQL5043N | 2008/07/21 15:07 by zero |