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 theSELECT,INSERT,REPLACE, …