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

[5.5.5 BP MB-33006] - Use CountTotal for count aggregate on full index scan

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 6.0.0, 5.5.3, 6.0.1, 5.5.4
    • 5.5.5
    • 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

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            jeelan.poola Jeelan Poola created issue -
            jeelan.poola Jeelan Poola made changes -
            Field Original Value New Value
            Link This issue relates to CBSE-6919 [ CBSE-6919 ]
            jeelan.poola Jeelan Poola made changes -
            Link This issue backports to MB-33700 [ MB-33700 ]
            jeelan.poola Jeelan Poola made changes -
            Link This issue relates to CBSE-6389 [ CBSE-6389 ]
            wayne Wayne Siu made changes -
            Fix Version/s Mad-Hatter [ 15037 ]
            wayne Wayne Siu made changes -
            Fix Version/s 5.5.5 [ 16166 ]
            wayne Wayne Siu made changes -
            Link This issue blocks MB-33967 [ MB-33967 ]
            deepkaran.salooja Deepkaran Salooja made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Resolved [ 5 ]
            deepkaran.salooja Deepkaran Salooja made changes -
            Actual End 2019-05-07 22:42 2019-06-19 17:27 (issue has been resolved)
            mihir.kamdar Mihir Kamdar (Inactive) made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            jose.molina Jose Molina made changes -
            Link This issue has to be done before CBSE-7102 [ CBSE-7102 ]
            akhil.mundroy Akhil Mundroy made changes -
            Link This issue is a backport of MB-33006 [ MB-33006 ]

            People

              deepkaran.salooja Deepkaran Salooja
              jeelan.poola Jeelan Poola
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty