================================================================================================
Expand: varying number of COUNT(DISTINCT)
================================================================================================

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.17.0-1008-azure
AMD EPYC 7763 64-Core Processor
2 distinct aggregates:                    Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
with sum - baseline (ratio 3)                      3193           3258          48          3.3         304.6       1.0X
with sum - optimized (ratio 3)                     3159           3204          58          3.3         301.3       1.0X
pure distinct - baseline (ratio 2)                 2067           2091          32          5.1         197.1       1.5X
pure distinct - optimized (ratio 2)                 615            630          10         17.1          58.6       5.2X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.17.0-1008-azure
AMD EPYC 7763 64-Core Processor
4 distinct aggregates:                    Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
with sum - baseline (ratio 5)                      6100           6132          27          1.7         581.8       1.0X
with sum - optimized (ratio 5)                     6096           6125          34          1.7         581.4       1.0X
pure distinct - baseline (ratio 4)                 4661           4700          57          2.2         444.5       1.3X
pure distinct - optimized (ratio 4)                 776            787          12         13.5          74.0       7.9X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.17.0-1008-azure
AMD EPYC 7763 64-Core Processor
6 distinct aggregates:                    Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
with sum - baseline (ratio 7)                      9574           9618          39          1.1         913.1       1.0X
with sum - optimized (ratio 7)                     9566           9613          38          1.1         912.3       1.0X
pure distinct - baseline (ratio 6)                 7822           7859          31          1.3         746.0       1.2X
pure distinct - optimized (ratio 6)                 815            830          20         12.9          77.8      11.7X

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.17.0-1008-azure
AMD EPYC 7763 64-Core Processor
8 distinct aggregates:                    Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
with sum - baseline (ratio 9)                     13967          14044          56          0.8        1332.0       1.0X
with sum - optimized (ratio 9)                    13965          14019          74          0.8        1331.8       1.0X
pure distinct - baseline (ratio 8)                11977          12028          66          0.9        1142.2       1.2X
pure distinct - optimized (ratio 8)                1491           1510          15          7.0         142.2       9.4X


================================================================================================
Expand: varying data characteristics (pure distinct)
================================================================================================

OpenJDK 64-Bit Server VM 17.0.18+8-LTS on Linux 6.17.0-1008-azure
AMD EPYC 7763 64-Core Processor
6 pure distinct aggs with varying data:   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
1K groups, moderate card - baseline                7831           7864          22          1.3         746.8       1.0X
1K groups, moderate card - optimized                854            860           4         12.3          81.4       9.2X
100K groups, moderate card - baseline             10319          10461         202          1.0         984.1       0.8X
100K groups, moderate card - optimized             3071           3138          56          3.4         292.9       2.5X
1K groups, low card (5 vals) - baseline            7635           7672          44          1.4         728.2       1.0X
1K groups, low card (5 vals) - optimized            718            728           8         14.6          68.5      10.9X
no grouping key - baseline                         5186           5287          68          2.0         494.5       1.5X
no grouping key - optimized                         403            408           3         26.0          38.5      19.4X


