var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Decrease Compile Time
I have a complex piece of query that compiles for about 7-8 seconds, follwed by 4-5 seconds execution.
How can I decrease the compile time? Are there any configuration parameters?
As this query is run from a tool, it is not possible to decrease the optimization level or to use parameter markers.
Environment : DB2 V8.2 - RH Linux
You could try setting DB2_REDUCED_OPTIMIZATION (see documentation for possible values). Obviously, this is going to affect all queries, not just the one you're concerned about.
or try including set current query optimization 0 in your sql