Fixing NLS_SORT for Jira Agile queries

XMLWordPrintable

    • 6.04

      JAG needs a better way of fixing the NSL_SORT in Oracle DB.
      Right now we are doing a forced NSL_SORT over the RANK column dropping the performance.

      Possibilities:

      1. Document this
      2. Do a migration script that force the database to NLS_SORT=Binary
      3. Try to fix the index or the column to use the proper NLS_SORT.

      The difference between this ticket and GHS-11162 is that we should take off the NLS_SORT while the other is about removing the function from the code.

              Assignee:
              Unassigned
              Reporter:
              Carlos Khatchikian
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: