JPAQueryFactory does not support query hint indexes.

[jeonjonghyeok]

Why the new feature should be added

I'm currently using the JPAQueryFactory feature well.

However, there are requirements.
An explicit INDEX hint is required within the SELECT query.

Since there is no function to set query index hint, we are using SQLQueryFactory to force mismatched tables to match inefficiently.
I would be really happy if there was a function to insert /*+ INDEX() */ right after the SELECT query.

It would be nice to add an index hint using JPAQuery's setHint() method.

How the new feature should work

AbstractCommonQueryContract 클래스의 applyHint(String hintName, Object value) 메소드에 enum 추가
HINT_DATABASE:
applyDatabaseHint();

MutableQueryOptions.addDatabaseHint(String hint)

[velo]

Well, if you are using hibernate, sadly you are out of luck.

But, if using eclipse links, you can jpaQuery.setHint(QueryHints.HINT, "INDEX()");

https://eclipse.dev/eclipselink/api/2.6/org/eclipse/persistence/config/QueryHints.html#HINT

I know no alternatives for hibernate, sorry.

You might want to try it on querydsl 5.1
https://github.com/OpenFeign/querydsl

[jherkel]

@velo Could you enable "issues" for your fork? I would like to create one issue (regression) for querydsl-apt module.

[velo]

Ops, done!

[velo]

@velo Could you enable "issues" for your fork? I would like to create one issue (regression) for querydsl-apt module.

@jherkel did you managed to raise the issue?

[jeonjonghyeok]

@velo hibernate/hibernate-orm#7925