[ https://issues.apache.org/jira/browse/OPENJPA-168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12480839 ]
Ritika Maheshwari commented on OPENJPA-168: ------------------------------------------- Abe is there a way from selectImpl to know if this is the top select or not.For example if EagerFetchMode set to parallel if we are trying to retrieve Department and department is eagerly fetching Emps.Then a single user query (select d from Department d) will produce multiple push down sqls.Now if the user set the hint to optimize on the top level query ie select d from Department d then it should appear only on the top level query and not the subsequent queries.But to do so we need the ability to be able to distinguish if this is the top select or not.Is there currently any mechanism to do this ritika > sql optimize n rows query hint > ------------------------------ > > Key: OPENJPA-168 > URL: https://issues.apache.org/jira/browse/OPENJPA-168 > Project: OpenJPA > Issue Type: New Feature > Reporter: David Wisneski > Assigned To: David Wisneski > > There werre various comments from Patrick, Abe and Kevin Sutter about the > code that I checked related to Optimize hint. So I have gone back and > relooked at this and wil be making some changes. At Kevin's suggestion I > will do this through a JIRA feature so that folks will have opportunity to > comment on this before the code is actually done and checked in. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.