SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OR condition in the where clause causing the performance?

User_AE8FXMay 22 2019 — edited May 24 2019

Hi All,

I have below NVL condition(before)

(
   NVL(PS.PAYMENT_METHOD_LOOKUP_CODE, 'CHECK')   = :B6
)

later i added OR condition and the PLSQL concurrent program is taking long time.. still running.

(
   NVL(PS.PAYMENT_METHOD_LOOKUP_CODE, 'CHECK')   = :B6
   OR NVL(PS.PAYMENT_METHOD_LOOKUP_CODE, 'WIRE') = :B6
)

Is this OR causing the issue?

Thank you,

Added on May 22 2019

24 comments

2,112 views