Tune query with "NOT IN"
From: konghou <brotherhou_at_yahoo.com>
Date: 12 Apr 2002 02:16:15 -0700
Message-ID: <c19678a1.0204120116.66434be8_at_posting.google.com>
Date: 12 Apr 2002 02:16:15 -0700
Message-ID: <c19678a1.0204120116.66434be8_at_posting.google.com>
How to tune the query:
select .... where (f1, f2) not in (select f3, f4 from ... )
A "not exist" seems working as slow.
Received on Fri Apr 12 2002 - 11:16:15 CEST