Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
None
-
None
-
None
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.
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.
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Status | New [ 10000 ] | Open [ 1 ] |
Fix Version/s | 1.7.13 [ 10902 ] |
Assignee | Jeffrey Klann [ jklann ] |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Resolved [ 5 ] |
Status | Resolved [ 5 ] | Closed [ 6 ] |