- Can we tune a Query which has its where clause dynamically changed ?

Hi All,

We are having an application coded on Java with Oracle 10g . In this application there is one query where a users submits a search.   The query can changes with the where clause being appended with new AND clauses . The selected columns do not change but based on the values on the screen the where clause will have those many AND clauses appended. Does any one have any idea how to handle such queries.

Appreciate your help.