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

Improve Database Indexes to the PROPERTYENTRY Table

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Duplicate
    • None
    • None
    • 17
    • 19
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      I am creating this issue as per the feedback from one of our customers.
      He reported that after his DBA reviewed their AWR reports, they noticed that a query to the PROPERTYENTRY table (copied below) was among the top queries by elapsed time and CPU time, gets and executions.

      SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM propertyentry WHERE ENTITY_NAME=:1 AND ENTITY_ID=:2 AND PROPERTY_KEY=:3

      After modifying an existing index for this table , they saw an improvement of 35 times in the access speed and CPU usage.
      This might be Oracle-specific, but I think we should review whether this index should not be modified during the JIRA installation.

              Unassigned Unassigned
              dconrad Danilo Conrad
              Votes:
              9 Vote for this issue
              Watchers:
              13 Start watching this issue

                Created:
                Updated:
                Resolved: