re: Improving SQL Query by Adding conditions in Joins VIEW POST

FULL DISCUSSION
 

In any decent optimizer, INNER JOIN and WHERE conditions are basically interchangeable.

Also, I'm suspicious about any index that starts on ID because they are highly selective from the start.

Would like to see the execution plans of the two different queries.

code of conduct - report abuse