Skip to main content
added 171 characters in body
Source Link
ypercubeᵀᴹ
  • 98.6k
  • 13
  • 215
  • 305

The queries are not equivalent, they will give different results, so there is very little gain in comparing their performance.

Query 1 has a condition about carriers (the table on the right side of the LEFT join) in the WHERE clause. That essentially converts the join to an INNER join.

The queries are not equivalent, they will give different results, so there is very little gain in comparing their performance.

The queries are not equivalent, they will give different results, so there is very little gain in comparing their performance.

Query 1 has a condition about carriers (the table on the right side of the LEFT join) in the WHERE clause. That essentially converts the join to an INNER join.

Source Link
ypercubeᵀᴹ
  • 98.6k
  • 13
  • 215
  • 305

The queries are not equivalent, they will give different results, so there is very little gain in comparing their performance.