We have a query (pretty complex) that we have investigating at
optimisation Levels and I am Little surprised at the results, and it
1.Package cache flushed before each running.
2.The majority of the elapsed time - 99% is spent preparing
statement - verified with db2batch
Level Elapsed time(ms)
Q1. If Level5 has heuristics to avoid spending too much time
what is a very short running query, why does it insist on
to Prepare for some 50 seconds on ...