[ 
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.

Reply via email to