Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsOracle Hints in subqueries
https://www.eclipse.org/forums/index.php/mv/msg/1105138/1832060/#msg_1832060
Eclipselink version: 2.6.9
How can i add custom hints in each subquery?
I'm trying to replicate the SQL below but I can't to set hints in the class javax.persistence.criteria.Subquery.
SELECT /*+ NO_PARALLEL */ a.name FROM UserData a WHERE EXISTS(
SELECT /*+ NO_UNNEST NO_PUSH_SUBQ */ 1 FROM UserData a WHERE a.name = "bla bla"
);
-- Note that I need is to set the NO_UNNEST && NO_PUSH_SUBQ in order to force the SQL optimizer to don't join the result of the subquery to the main body.
Could you help me in that point? I don't know if there is any official way to accomplish this goal, or if i need to set it as a literal in the subquery' select...