title: How to insert an "Optimizer hint" to Hibernate criteria api query
body: <p>i have a hibernate query that is dynamically put together using the criteria api.
  it generates queries that are unbearably slow, if executed as-is.</p>
  
  <p>but i have noted they are about 1000% faster if I prepend /*+ FIRST_ROWS(10) */ to the query. how can i do this with the criteria api?</p>
  
  <p>i tried criteria.setComment(..), but this seems to be ignored.</p>
  
  <p>in the hibernate docs, 3.4.1.7. Query hints are mentioned, but it clearly states: "Note that these are not SQL query hints"</p>
  
  <p>the result of the query will be paginated, so in 99% of the cases i will display the results 1-10.</p>