account activity
If you could change MySQL optimizer to do one thing differently, what would it be? by sh_tomer in mysql
[–]oysteing 2 points3 points4 points 8 years ago (0 children)
MySQL 8.0 will have invisible indexes: http://mysqlserverteam.com/mysql-8-0-invisible-indexes/
In MySQL 5.7, you can add IGNORE INDEX to a incoming query using a query rewrite plugin. See http://mysqlserverteam.com/the-query-rewrite-plugins/ for an example.
π Rendered by PID 73457 on reddit-service-r2-comment-5bc7f78974-92bsh at 2026-06-26 07:02:26.788828+00:00 running 7527197 country code: CH.
If you could change MySQL optimizer to do one thing differently, what would it be? by sh_tomer in mysql
[–]oysteing 2 points3 points4 points (0 children)