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

Bandana table has no index on context + key

    XMLWordPrintable

Details

    Description

      The most common lookup on the bandana table is to look up entries by context & key together. However, there is index on this pair of columns, although they both have individual indices. It would seem better to drop the index on key alone and replace it with one on context + key.

      There is a long-standing open issue to create a unique constraint on CONF-7787 which would also make a lot of sense, but may be more difficult since we would have to handle (or delegate to support) any existing duplicates.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: