Is a JOIN faster than a WHERE?

by

Theoretically, no, it shouldn’t be any faster. The query optimizer should be able to generate an identical execution plan. However, some database engines can produce better execution plans for one of them (not likely to happen for such a simple query but for complex enough ones). You should test both and see (on your database engine).

More Related Contents:

  1. SQL JOIN – WHERE clause vs. ON clause
  2. SQL JOIN: is there a difference between USING, ON or WHERE?
  3. Subqueries vs joins
  4. Difference between Oracle’s plus (+) notation and ansi JOIN notation?
  5. Filter Table Before Applying Left Join
  6. Does the order of where clauses matter in SQL?
  7. SQL Joins Vs SQL Subqueries (Performance)?
  8. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  9. IN vs. JOIN with large rowsets
  10. sql query joins multiple tables – too slow (8 tables)
  11. What is the result of following SQL Query?
  12. How does database indexing work? [closed]
  13. Join vs. sub-query
  14. SQL – HAVING vs. WHERE
  15. Can I use CASE statement in a JOIN condition?
  16. What is the difference between Left, Right, Outer and Inner Joins? [duplicate]
  17. Condition within JOIN or WHERE
  18. Difference between left join and right join in SQL Server [duplicate]
  19. SQL Join Differences
  20. Fastest way to remove non-numeric characters from a VARCHAR in SQL Server
  21. Select only rows by join tables max value
  22. What’s the difference between “where” clause and “on” clause when table left join?
  23. What is semi-join in database?
  24. SQL performance: WHERE vs WHERE(ROW_NUMBER)
  25. How to check which locks are held on a table
  26. SQL server join tables and pivot
  27. When using GETDATE() in many places, is it better to use a variable?
  28. Challenge,how to implement an algorithm for six degree of separation?
  29. Entity Framework Skip/Take is very slow when number to skip is big
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment