Re: Replace NOT IN w/ NOT EXISTS ?

 dan.bikle_at_octel.com (Dan Bikle) writes:
>select ename from emp
>where empno NOT IN
>(select empno from empexclude)
>/
>can be replaced by a quicker method.
>something like:
>select ename from emp
>where NOT EXISTS ...
>
>I forget the rest.

The faster query in ORACLE is to use an outerjoin:

	select ename from emp, expexclude
	where emp.empno = empexclude.empno (+)
	and empexclude.empno is null

-- 
							Yoichi Tamura
							y-tamura_at_nri.co.jp