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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

1,999 views