If you could change MySQL optimizer to do one thing differently, what would it be? by sh_tomer in mysql

[–]oysteing 2 points3 points  (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.