MySQL Forums :: Performance :: Multiple inner join Query with NOT IN takes forever to execute for large resultset
Re: Multiple inner join Query with NOT IN takes forever to execute for large resultset
Posted by: Rick James ()
Date: November 10, 2009 10:05PM
NOT IN (SELECT...) is not well optimized. Change it to a LEFT JOIN ... IS NULL.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Multiple inner join Query with NOT IN takes forever to execute for large resultset | 236 | infinity heaven | 11/09/2009 10:18AM |
| Re: Multiple inner join Query with NOT IN takes forever to execute for large resultset | 133 | Rick James | 11/10/2009 10:05PM |
Sorry, only registered users may post in this forum.
© 1995-2008 MySQL AB, 2008- Sun Microsystems, Inc.