How can I make it faster? Help needed.

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 Received on Mon Apr 19 1999 - 11:26:34 CEST