Feb 16, 2022
Your implementation is better.
Unnecessarily using joins to subset is inefficient. WHERE clauses execute prior to JOIN, limiting the data actually passed into a join.
Your implementation is better.
Unnecessarily using joins to subset is inefficient. WHERE clauses execute prior to JOIN, limiting the data actually passed into a join.