Major Description
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
Attachments
Issue Links
- links to
