Details
-
Bug
-
Resolution: Fixed
-
Critical
-
5.5.3, 5.5.4, 6.0.0, 6.0.1
-
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
For Gerrit Dashboard: MB-33006 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
107477,9 | MB-33006 optimize count for full index scan | unstable | indexing | Status: MERGED | +2 | +1 |
113096,3 | Test cases for MB-33006, fast count. | master | testrunner | Status: MERGED | +2 | +1 |