Hi,
I have severe performance problem with compilation of sql-queries. So
I wanted to ask, if there is another better way to create our queries
to avoid many compilations:
I must to notice that I DO use PreparedStatement.

small example:
say I have table(key - primary key, field1, field2)
1. Select * from table where key = ?
2. Select * from table where key = ? or key = ?
3. Select * from table where key = ? or key = ? or key = ?(another way
to write this is
select * from table where key in (?, ?, ?)
Number of key-options supplied by user and user can choose for what
keys select should be executed.
Every key is not logically-connected to another by any other field,
i.e. I can't rewrite query to something like: select * from table
where field1 = ?

So my statement-cache thinks that all three queries are different,
since the texts of queries are different, so in three cases I got
query-compilation in data-base...

My solution-try was to create query with fixed number of options for
example:
select * from table where key = ? or key = ? or key = ?
and if user supplies less then 3 keys I'll duplicate last key and if
user supplies more than 3 keys I'll prepare statement once and each
time execute with 3 key-options and at the end collecting all results
for user.

My question is : is there another way to write such
queries(dynamically changing number of option in key predicate) such
that I'll get cache-hit?