In version MySQL 5.7.7 Oracle presented a new promising feature: optimizer hints. However it did not publish any documentation about the hints. The only note which I found in the user manual about the hints is: It is now possible to provide hints to the optimizer by including /*+ ... */ comments following the SELECT, [&]

The post Optimizer hints in MySQL 5.7.7  The missed manual appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/04/30/optimizer-hints-mysql-5-7-7-missed-manual/