Uploaded image for project: 'i2b2 Core Software'
  1. i2b2 Core Software
  2. CORE-399

Oracle index hints must use the table alias

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 1.7.13
    • 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.

      Attachments

        Activity

          jklann Jeffrey Klann created issue -
          jklann Jeffrey Klann made changes -
          Field Original Value New Value
          Status New [ 10000 ] Open [ 1 ]
          jklann Jeffrey Klann made changes -
          Fix Version/s 1.7.13 [ 10902 ]
          rm302 Reeta Metta made changes -
          Assignee Jeffrey Klann [ jklann ]
          jklann Jeffrey Klann made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          rm302 Reeta Metta added a comment -
          will not be tested
          rm302 Reeta Metta added a comment - will not be tested
          rm302 Reeta Metta made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

          People

            jklann Jeffrey Klann
            jklann Jeffrey Klann
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: