[teiid-issues] [JBoss JIRA] (TEIID-1726) Requesting ability to add/use Oracle hints in EDS

[Steven Hawkins (Commented) (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12640466#comment-12640466 ] 

Steven Hawkins commented on TEIID-1726:
---------------------------------------

Here's what I'm working towards:

The initial implementation will be a multi-hint container hint of the form "sh(:'arg')? translator-name:'arg' ...", where the hint args follow the parsing rules for string literals.  For example:

select /*+ sh:'foo' oracle:'all_rows' */ x, y ...

Since we are already breaking encapsulation, there is no direct support for referencing Teiid columns/tables.  It is expected that the user will know the appropriate block name and or source names that their hint affects.  If a user wishes they can expand on this technique to include fully qualified Teiid names in the hint and then use the runtime metadata facility to lookup appropriate source metadata (and they would also potentially need the appropriate correlation name).  Note that we could leave off the notion of a general hint for now, but it seems useful to have a single place to specify a hint that can be passed to all sources.

The translators will receive the source hint (both the general sh argument if specified and the translator specific if available) from the top most level query providing a hint.  New methods may be needed on the ExecutionContext to support this.  Hints from a subquery, or joined/unioned view will be ignored. 

Only the oracle translator will do anything with these hints to begin with.  If a hint is specified, then it will be placed in the source query surrounded by /*+ */.

These source hints will be expected to appear after the first token in the query and can appear on user queries, view definitions, or in virtual procedure command statements (a minor amount of additional effort would also allow them to appear in arbitrary virtual procedure expressions).

Also available in 7.6 is support for native-query metadata on source tables/procedures - see TEIID-669 and the reference.

Let me know if you have any concerns.
                
> Requesting ability to add/use Oracle hints in EDS
> -------------------------------------------------
>
>                 Key: TEIID-1726
>                 URL: https://issues.jboss.org/browse/TEIID-1726
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Server
>    Affects Versions: 7.4.1
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>             Fix For: 7.6
>
>
> Requesting the ability to use Oracle hints inside virtual transformations and enduser queries in EDS and Teiid Designer

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira