Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-19409

Missing index in OS_HISTORYSTEP impacts delete project performance

    XMLWordPrintable

Details

    Description

      "DELETE FROM OS_HISTORYSTEP WHERE ENTRY_ID='XXXXXX'" statements part of the delete project operation take ages on a large issue database by having to scan the table on each statement. An index on ENTRY_ID improves hugely the delete performance.

      Attachments

        Activity

          People

            rsmart metapoint
            38754ddc40c7 angel
            Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: