Alternative for NVL function
801619Jul 4 2011 — edited Jul 5 2011Hi Experts,
I working in 11.5.10 EBS and database 9i.
I have below query
begin
select empno,ename, sal, job
from emp
where empno=nvl(:eno,empno)
and ename=nvl(:ena,ename);
end;
Note: I have 10 nvl's in my query.
If i don't pass any parameter,it's taking very long time because of nvl condition. Could somebody help me how to improve the performance of above query, is there any alternative other than NVL function.
Kindly help me.
Thanks in advance.