Hi,

How can i reduce query optimization in the select query? something like this SET CURRENT QUERY OPTIMIZATION=0 ; or how can i define the optimization level for all the sessions of a particular id?

Thanks,
Waseem

The CURRENT QUERY OPTIMIZATION special register has session scope. Thus, you set it once and all subsequent SQL statements will use this optimization level. As a global setting for a database, you can change the DB CFG parameter DFT_QUERYOPT.

I believe there may be even an option to set the optimization level for the current statement only. I just don't recall the details of that, however.