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.
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
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.