[CORE-399] Oracle index hints must use the table alias Created: 20/Oct/20 Updated: 30/May/22 Resolved: 29/Mar/22 |
|
Status: | Closed |
Project: | i2b2 Core Software |
Component/s: | None |
Affects Version/s: | None |
Fix Version/s: | 1.7.13 |
Type: | Bug | Priority: | Minor |
Reporter: | Jeffrey Klann | Assignee: | Jeffrey Klann |
Resolution: | Fixed | Votes: | 0 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Participant/s: |
Description |
From Lav Patel at KUMC:
After doing some testing at KUMC and reading an article at http://www.dba-oracle.com/t_oracle_index_hint_syntax.htm , it seems like i2b2 oracle index hint syntax is wrong. Here is what articles says: Also note that of you alias the table, you must use the alias in the index hint: select /*+ index(c cust_primary_key_idx) */ * from customer c;. I also found this true in my testing. |
Comments |
Comment by Reeta Metta [ 30/May/22 ] |
will not be tested |