Subqueries vs joins

by

A “correlated subquery” (i.e., one in which the where condition depends on values obtained from the rows of the containing query) will execute once for each row. A non-correlated subquery (one in which the where condition is independent of the containing query) will execute once at the beginning. The SQL engine makes this distinction automatically.

But, yeah, explain-plan will give you the dirty details.

More Related Contents:

  1. How can I do a FULL OUTER JOIN in MySQL?
  2. INNER JOIN ON vs WHERE clause
  3. Join vs. sub-query
  4. SQL JOIN: is there a difference between USING, ON or WHERE?
  5. Best way to test if a row exists in a MySQL table
  6. Difference between Oracle’s plus (+) notation and ansi JOIN notation?
  7. Why would an IN condition be slower than “=” in sql?
  8. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  9. SQL Joins Vs SQL Subqueries (Performance)?
  10. Importance of varchar length in MySQL table
  11. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  12. single fixed table with multiple columns vs flexible abstract tables
  13. How many rows in a database are TOO MANY?
  14. Why does this SQL code give error 1066 (Not unique table/alias: ‘user’)?
  15. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  16. MySQL – Selecting data from multiple tables all with same structure but different data
  17. Is a JOIN faster than a WHERE?
  18. How to create a multi-tenant database with shared table structures?
  19. MySQL: GROUP_CONCAT with LEFT JOIN
  20. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  21. MySQL – how to front pad zip code with “0”?
  22. IN vs. JOIN with large rowsets
  23. When to use a left outer join?
  24. Two single-column indexes vs one two-column index in MySQL?
  25. How important are lookup tables?
  26. sql query joins multiple tables – too slow (8 tables)
  27. SQL JOIN and different types of JOINs
  28. Is a view faster than a simple query?
  29. SQL Server 2008 paging methods?
  30. MySQL Join Multiple Rows as Columns

Leave a Comment