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

Oracle index hints must use the table alias

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 1.7.13
    • None
    • None
    • Rank:
      0|s000k0:

    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

          People

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

            Dates

              Created:
              Updated:
              Resolved: