I'm facing performance issue when i use multi selection (IN operator) in apex. Please help me to fix this
SELECT *
FROM Q1
WHERE Q1.sample IN (SELECT COLUMN_VALUE
FROM TABLE(APEX_STRING.SPLIT(NVL(:P34_ACC,Q1.sample ),',')))
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
Why are you using the Q1.sample column with NVL in the subquery? That is why it is getting slow.
Use a static value with NVL().