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

            Sen made changes -
            Workflow Original: JAC Suggestion Workflow 4 [ 3567347 ] New: JAC Suggestion Workflow 3 [ 4332619 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow 2 [ 3176740 ] New: JAC Suggestion Workflow 4 [ 3567347 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3034665 ] New: JAC Suggestion Workflow 2 [ 3176740 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing v4 [ 2522806 ] New: JAC Suggestion Workflow [ 3034665 ]
            Rachel Lin (Inactive) made changes -
            Workflow Original: Confluence Workflow - Public Facing v3 [ 2256239 ] New: Confluence Workflow - Public Facing v4 [ 2522806 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing v3 - TEMP [ 2153304 ] New: Confluence Workflow - Public Facing v3 [ 2256239 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing v3 [ 1935884 ] New: Confluence Workflow - Public Facing v3 - TEMP [ 2153304 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing v2 [ 1758114 ] New: Confluence Workflow - Public Facing v3 [ 1935884 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Suggestion WF (TEMP) [ 1694015 ] New: Confluence Workflow - Public Facing v2 [ 1758114 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing [ 1366135 ] New: CONF Suggestion WF (TEMP) [ 1694015 ]

              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: