I have a performance issue with an LOV with 1 bind parameter. In the LOV I use Advanced search (on the same page).
If I do not fill in a value in the original field and click on the flashlight next to this field the query of the LOV is being executed with the value of the bind parameter (which is not empty), but without the extra search criteria in the LOV. This causes performance issues because a full table scan is being executed.
Do you have a suggestion how to solve this behaviour?
How can I prevent the query of the LOV being executed before filling in the search fields?
I have solved the issue with LOVs mentioned in Oracle document 1356605.