Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
6.0.0, 5.5.3, 6.0.1, 5.5.4
-
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-34624 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
110900,1 | MB-34624 optimize count for full index scan | vulcan | indexing | Status: MERGED | +2 | +1 |
Wayne Siu, yes we decided to include it in 5.5.5 as multiple customers have requested for it. The code has been isolated so it can be turned off using a config setting in case of any issues.