Home » Developer & Programmer » Reports & Discoverer » EXISTS operator performance
EXISTS operator performance [message #90162] Sun, 21 November 2004 23:04
Jagdish
Messages: 43
Registered: September 2003
Member
SELECT count(*)
  FROM emp
 Where exists (select 'X' From dept
                    where dname like 'A%'
                       and dept.deptno=emp.deptno)
 /

select count(*) from emp e,dept d
where e.deptno = d.deptno
   and d.dname like 'A%'
/

which query is best in performance? how exists operator works?
Previous Topic: Reprort 9i Problem
Next Topic: Using lexical parameters to create hints?
Goto Forum:
  


Current Time: Fri Feb 23 17:21:54 CST 2024