|
|
|
Question - In SQL is LEFT JOIN faster than NOT IN
[
Categories -
Computer Programming ---
Suggest category
]
  "You can clearly observe that first query with NOT IN takes 20% resources of execution plan and LEFT JOIN takes 80% resources of execution plan. It is better to use NOT IN clause over LEFT JOIN in this particular example. Please note that this is not generic conclusion and applies to this example only. Your results may vary on many factors. Let me know your comments if you have guessed this correct or not."
http://blog.sqlauthority.com/2008/04/22/sql-server-better-performance-left-join-or-not-in/
Can you answer this question?
Login
Or Signup
Similar Feedbo Pages
How do I make my website load faster? What the cut off age to join the Marine Reserves? What does my penis hang to the left? Is Chinese food better than Japanese food? Are the Red Sox better than the Yankees? Is Garmin better than TomTom? Why is Firefox better than Internet Explore? Is firefox better than google chrome? Why are men always more skeptical than women? Has anyone ever gotten more than 60 minutes of actual use out of their iPhone 3G? |
