Skip to content

Instantly share code, notes, and snippets.

@zerofudge

zerofudge/gist:1299123

Created October 19, 2011 17:59
Show Gist options
  • Save zerofudge/1299123 to your computer and use it in GitHub Desktop.
Save zerofudge/1299123 to your computer and use it in GitHub Desktop.
Download ZIP
oracle hints in hql
Raw
gistfile1.java
String hql = "/*+ INDEX(stock idx_stock_code) */
select * from stock s where s.stock_code = :stockCode";
List result = session.createQuery(hql)
.setString("stockCode", "7277")
.list();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment