cow.vs.cow Posted February 9, 2009 Share Posted February 9, 2009 hello all ! i hope you'll have some good answers for me. lest start. i have 3 tables A - inno_db - has 500,000 records B - inno_db - has 40,000 records C - temporary table - inno_db - has 80,000 records all tabels are growing up more and more. i need all the records from A that they are NOT in B AND NOT in C using NOT IN is taking way to long and i'm sure that there's another better way.. thanx all Quote Link to comment Share on other sites More sharing options...
fenway Posted February 9, 2009 Share Posted February 9, 2009 Yup... it's called a LEFT JOIN. Quote Link to comment Share on other sites More sharing options...
cow.vs.cow Posted February 9, 2009 Author Share Posted February 9, 2009 i have tried it. isn't anything faster than this ? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 15, 2009 Share Posted February 15, 2009 i have tried it. isn't anything faster than this ? Faster then a left join... unlikely. Let's see the EXPLAIN output for each one. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.