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?

Report message to a moderator

Previous Topic: Reprort 9i Problem
Next Topic: Using lexical parameters to create hints?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 01 23:10:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.