Closed missinglink closed 2 years ago
following on from https://github.com/pelias/placeholder/pull/218 this PR rewrites the queries again to help nudge the query planner in the right direction.
previously it didn't really matter if the $subject matching happened in the ON or a WHERE condition, with the additional matching condition I think its better to have it in the ON.
ON
WHERE
following on from https://github.com/pelias/placeholder/pull/218 this PR rewrites the queries again to help nudge the query planner in the right direction.
previously it didn't really matter if the $subject matching happened in the
ONor aWHEREcondition, with the additional matching condition I think its better to have it in theON.