[
https://issues.apache.org/jira/browse/TRAFODION-2569?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hans Zeller resolved TRAFODION-2569.
------------------------------------
Resolution: Fixed
> Improve handling of index hints
> -------------------------------
>
> Key: TRAFODION-2569
> URL: https://issues.apache.org/jira/browse/TRAFODION-2569
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: sql-cmp
> Affects Versions: 2.0-incubating
> Reporter: Hans Zeller
> Assignee: Hans Zeller
> Fix For: 2.2-incubating
>
>
> We allow index hints of this form:
> select ... from table1 <<+index TRAFODION.SCH.IX1>> ...
> In many cases, the compiler does not choose the index specified in the hint,
> however. A few improvements I am planning to do, if I can pull it off:
> * if we need an index join, make sure we get it using this index
> * allow hints in update statements
> * bind the names in the hint, so they don't have to be specified as
> upper-case 3-part names.
> * issue a warning if the table name in the index does not specify an index
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
