This discussion is archived
1 Reply Latest reply: May 24, 2013 4:17 AM by Roel RSS

Performance depending on condition expression type

scott.wesley Guru
Currently Being Moderated
Hi all,

I was just wondering what people's thoughts and experiences are regarding performance of conditional expressions.

Tony blogs about it here

And gives the example
1) Value of item/column in Expression 1 = Expression 2
Expression 1: P1_JOB
Expression 2: SALESMAN

2) PL/SQL Expression

Expression 1: :P1_JOB = ‘SALESMAN’>
Recently I've been trying to eke every shortcut I can with an application and noticed this can be a contributing factor when done dozens of times within a page render.




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