Hi,
I have a doubt regarding how the following dynamic queries will be executed from a preparedstatement in Java.

1) Select name, age,salary from employee where id in (?)

2) Select name, age,salary from employee where id in (?,?)

3) Select name, age,salary from employee where id in (?,?,?)

Will the query optimization happen only once or will DB2 treat each of the above queries as a different query and do optimization, do hard parsing and softparsing or it will only do soft parsing for 2 and 3.

These will be treated as three different queries.

The simple reason is that all 3 queries can lead to different access paths, i.e. because of the selectivity values.