Re: Index Usage using IN

["Jeffrey W. Baker" <jwbaker@xxxxxxx>]

On Thu, 2006-02-02 at 09:12 +1300, Ralph Mason wrote:
> Hi,
> 
> I have 2 tables both have an index on ID (both ID columns are an oid).
> 
> I want to find only only rows in one and not the other.
> 
> Select ID from TableA where ID not IN ( Select ID from Table B)

Have you considered this:

SELECT ID from TableA EXCEPT Select ID from Table B

?

-jwb