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.