ryanvs


Comments:

SQL SERVER - Better Performance - LEFT JOIN or NOT IN?

posted by ryanvsryanvs(75) 4 years, 1 month ago 0

Be careful! This is interesting, but the comments are more interesting. The best comment is #7 from Jason. To summarize, index the tables and use LEFT JOIN unless there is very good reason to do otherwise.

Reply

Submit a Story