Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-14488

There should be a composite index on some of the columns in SpacePermissions table

XMLWordPrintable

    • We collect Confluence 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.

      Most of the commonly used queries on the SpacePermissions table are queries on the permtype, user and group columns together, but we have no composite index on these columns.

      Adding one should greatly improve performance to these queries.

      This change creates very little risk, since the Space Permissions table is very rarely updated.

      One large system experienced improved performance when such an index was added to its oracle database.

      Note that this index might be ineffective in some systems because the column values and the query values involve NULLs, which can sometimes limit the effectiveness of an index.

            [CONFSERVER-14488] There should be a composite index on some of the columns in SpacePermissions table

            No work has yet been logged on this issue.

              don.willis@atlassian.com Don Willis
              don.willis@atlassian.com Don Willis
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: