Support for Native/SQL Query Hints in Entity Mappings

Description

When defining entity mappings, it would be really useful to be able to provide optimizer hints to associations.

Much like the FetchType, the ability to provide a dialect specific query hints (i.e Oracle's +ALL_ROWS, +RESULT_CACHE etc.) for fetching would greatly improve performance in various implementations.

Query created to select from Department table using Oracle dialect would include:

Thank you for your consideration.

Environment

None

Assignee

Unassigned

Reporter

Erdem Memisyazici

Fix versions

None

Labels

None

backPortable

Backport?

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure