Ability to Change the MySQL Optimizer Behavior
As a database administrator or developer,
I would like to be able to change the behavior of the MySQL Optimizer at the global level by changing the variable of the optimizerswitch with values such as "indexmergeintersection=off" or "preferordering_index=off",
so that I would be able to optimize my query performance.
2
votes
AdminSurya Murugaian
(Support Engineer, Aiven.io)
shared this idea
-
Another interesting optimizer_switch: prefer-ordering-index
https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html#optflag_prefer-ordering-index
Explanations:
https://hackmysql.com/post/infamous-order-by-limit-query-optimizer-bug/
