Re: SQL challenge;-)

Frank an der Heiden wrote:

> this sql-statement works:
>
> SELECT <column> FROM <table1> WHERE <column> NOT IN (SELECT <column> FROM
> <table2>);
>
> but it is very very slow, because the second select is done very often if
> you have many rows in table1.
> any simple idea for improving performance?

select column from table1
minus
select column from table2;

-- 
 .-.   .-.    Sarcasm is just one more service we offer.
(_  \ /  _)
     |        dave_at_arsdigita.com
     |