Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-10030

db2: queries that use 'lower' do not use index because of case sensitivity

    XMLWordPrintable

Details

    • 5

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

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

      Most of the queries against CONTENT table use 'lower' db function for a title field. The goes for (space) key field in SPACES table.
      We do it to make a case insensitive comparison, however it means that db2 does not use the existing indexes for those fields and performs a full table scan.
      This results in a poor performance.

      This can be applicable to other database too, but it is not verified. Also other databases may have global 'case sensitivity' flag.

      Attachments

        1. lower-func-performance.patch
          34 kB
        2. lower-func-performance.patch
          28 kB
        3. lower-func-performance.patch
          18 kB
        4. lower-func-performance.patch
          19 kB
        5. lower-func-performance.patch
          3 kB

        Issue Links

          is related to

          Suggestion - CONFSERVER-10030 db2: queries that use 'lower' do not use index because of case sensitivity

          • Closed
          was cloned as

          Suggestion - CONFCLOUD-11577 Store pre-lowercased content titles for more efficient lookup

          • Closed

          Activity

            People

              matt@atlassian.com Matt Ryall
              akazatchkov Anatoli
              Votes:
              11 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: