3 ms·
Author here, you are indeed correct that Query #2's final join can be an INNER join. However, I just tested it against our test data set and it makes no impact
by Albert_Camus 6y ago
Author here, you are indeed correct that Query #2's final join can be an INNER join. However, I just tested it against our test data set and it makes no impact on the performance.
- tech2 6y agoAh well, thanks for humouring me. Good thing those query optimisers do the right thing on occasion.