Unless the subquery is correlated, you can reformulate it as a join.
I thought I saw a doc somewhere showing alternatives to using IN() for better performance, but can't find it :(. Are there better performing query alternatives to this?
delete from tab1 where id in (select id2 from tab2 where ...);
Where the subquery returns 1-10K's of records.
John
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now