Hans Zeller created TRAFODION-2569:
--------------------------------------
Summary: 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)
