[teiid-issues] [JBoss JIRA] Created: (TEIID-1474) Add query hint to limit parallel execution of union members

[Howard Abrams (JIRA)]

Add query hint to limit parallel execution of union members
-----------------------------------------------------------

                 Key: TEIID-1474
                 URL: https://issues.jboss.org/browse/TEIID-1474
             Project: Teiid
          Issue Type: Feature Request
            Reporter: Howard Abrams
            Assignee: Steven Hawkins


We would like a new query hint to limit the number of parallel executions of union members. This is useful in two situations:
1. When the queries are expensive, but the overall union contains a limit that is most likely to be fulfilled by the first member of the union
2. When the queries are backed by a common resource which may be overloaded by multiple queries

The addition of a hint would make this manageable by the client; perhaps something like "/*+ parallel=2*/"? 

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira