[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
Generated at Thu Jul 17 06:42:39 UTC 2025 using Jira 8.20.11#820011-sha1:0629dd8d260e3954ece49053e565d01dabe11609.