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

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


    • 5
    • 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.

      NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? 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.

        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

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