@PersistenceContext
EntityManager em；
public List<DTO> findResultList(String column1, String column2) {
String sql = "select /*+INDEX(t INDEX_NAME)*/ t.* from table_name t where t.column_name1 = :column1 and t.column_name2 = :column2";//t 为表的别名
Query query = em.createNativeQuery();//走原生sql
query.setParameter("column1", column1);//入参1
query.setParameter("column2", column2);//入参2
List<DTO> list = query.getResultList();
if (list != null && list.size() > 0) {
return list;
}
return null;
}
Oracle使用EntityManager强制hint索引查询
原文：https://www.cnblogs.com/a9292/p/12131833.html