title: Mysql index hints in Hibernate query
body: <p>How can we specify Mysql index hints in Hibernate query ?</p>
  
  <p>Using index hints in Mysql queries becomes imperative in cases where query planner doesn't choose right indexes (ref: <a href="https://www.percona.com/blog/2012/12/14/the-optimization-that-often-isnt-index-merge-intersection/" rel="nofollow noreferrer">https://www.percona.com/blog/2012/12/14/the-optimization-that-often-isnt-index-merge-intersection/</a>).</p>
  
  <p>This can be easily done through raw query as specified here: <a href="https://dev.mysql.com/doc/refman/5.7/en/index-hints.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/5.7/en/index-hints.html</a></p>