3 ms·
> You can still get surprised by query optimizations on relatively simple joins just changing query strategy when hitting tuning parameters. I imagine there is
by marcosdumay 4y ago
> You can still get surprised by query optimizations on relatively simple joins just changing query strategy when hitting tuning parameters.
I imagine there is a large bias about caring or not about this depending on what DBMS you are used to.
It just happens that on some DBMS you get "surprised" as "oh, shit, this problem again", and on others it usually comes as a surprise as "wait, I never thought about optimizer limits". The second set is much more prone to automating.