3 ms·
I was actually surprised that it mattered. I had expected the query optimizer to figure out the logical equivalent between the two and then pick the most optima
by sverhagen 3y ago
I was actually surprised that it mattered. I had expected the query optimizer to figure out the logical equivalent between the two and then pick the most optimal one for me.
- paol 3y agoSame here. I would have expected the OR an IN versions to generate the same query plan, it's seems like low hanging fruit for the query optimizer.