Re: How can I make it faster? Help needed.

How about...

SELECT DISTINCT m.cust_no
FROM message m
MINUS
SELECT DISTINCT c.cust_no
FROM customer c;

...seems to work well (<5 seconds) on multiple 100K row tables.

Good Luck.

mike.

"Dr. Wei Ho" wrote:
>
> Hi,
>
> Can anybody out there help me to make the following query faster.
>
> Both tables, MESSAGE and CUSTOMER, in the query have about 13,000
> records. In both tables, the fields CUST_NO are indexed.
>
> SELECT m.cust_no
> FROM message m
> WHERE m.cust_no
> NOT IN (SELECT c.cust_no FROM customer c);
>
> Thanks
>
> Wei

-- 
/------------*------------\
| Michael Langholz        |
* NeoMagic Corporation    *
| langholz_at_neomagic.com   |
\------------*------------/