Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-33006

Use CountTotal for count aggregate on full index scan

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 6.5.0
    • 5.5.3, 5.5.4, 6.0.0, 6.0.1
    • secondary-index
    • Untriaged
    • No

    Description

      Using CountTotal for count aggregate on full index scan (leading key, no group by) can improve the query performance by a big factor as the count is precomputed.

      Attachments

        Issue Links

          Activity

            People

              deepkaran.salooja Deepkaran Salooja
              deepkaran.salooja Deepkaran Salooja
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty