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