1 Reply Latest reply on May 24, 2013 11:17 AM by Roel Hartman

    Performance depending on condition expression type

    Scott Wesley
      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.