Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-11169

Fixing NLS_SORT for Jira Agile queries

    XMLWordPrintable

Details

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: