HINT_RESULT_COUNT

HINT_PARAM_MARKER_IN_QUERY

Hints to signal that the JPQL/SQL query string contains a parameter
marker ? character. By default, the query string is parsed
to count number of parameters assuming that all ? characters
designate a bind parameter. This assumption makes the parse faster.

HINT_INVALIDATE_PREPARED_QUERY

A directive to invalidate any prepared SQL that might have been cached
against a JPQL query. The target SQL corresponding to a JPQL depends on
several context parameters such as fetch configuration, lock mode etc.
If a query is executed repeatedly and hence its SQL is cached for faster
execution then if any of the contextual parameters change across query
execution then the user must supply this hint to invalidate the cached
SQL query.
The alternative to monitor any such change for automatic invalidation
has a constant performance penalty for the frequent use case where a
query is repeatedly executed in different persistent context with the
same fetch plan or locking.

HINT_IGNORE_PREPARED_QUERY

A directive to ignore any prepared SQL that might have been cached
against a JPQL query. The target SQL corresponding to a JPQL depends on
several context parameters such as fetch configuration, lock mode etc.
If a query is executed repeatedly and hence its SQL is cached for faster
execution then if any of the contextual parameters change across query
execution then the user must supply this hint to ignore the cached
SQL query for the current execution.
This is in contrast with invalidation hint that removes the cached
version from cache altogether.
The cached SQL is retained and subsequent execution of the same query
string without this hint will reuse the cached SQL.