This discussion is archived
2 Replies Latest reply: Nov 21, 2012 11:09 PM by 888634 RSS

Performance issue with LOV

888634 Newbie
Currently Being Moderated
JDeveloper 10.1.3.5.0
JHeadstart 10.1.3.1.26

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?

P.s.
I have solved the issue with LOVs mentioned in Oracle document 1356605.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points