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

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-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)                      3035           3073          50          3.5         289.5       1.0X
with sum - optimized (ratio 3)                     2930           2988          35          3.6         279.4       1.0X
pure distinct - baseline (ratio 2)                 2032           2051          16          5.2         193.8       1.5X
pure distinct - optimized (ratio 2)                 639            654          14         16.4          60.9       4.8X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-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)                      5897           5916          31          1.8         562.4       1.0X
with sum - optimized (ratio 5)                     5856           5889          20          1.8         558.5       1.0X
pure distinct - baseline (ratio 4)                 4332           4383          38          2.4         413.1       1.4X
pure distinct - optimized (ratio 4)                 789            800           7         13.3          75.3       7.5X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-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)                      9436           9526          69          1.1         899.9       1.0X
with sum - optimized (ratio 7)                     9430           9458          27          1.1         899.3       1.0X
pure distinct - baseline (ratio 6)                 7435           7462          32          1.4         709.0       1.3X
pure distinct - optimized (ratio 6)                 820            834          13         12.8          78.2      11.5X

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-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)                     13720          13795          53          0.8        1308.4       1.0X
with sum - optimized (ratio 9)                    13720          13751          28          0.8        1308.4       1.0X
pure distinct - baseline (ratio 8)                11483          11527          34          0.9        1095.1       1.2X
pure distinct - optimized (ratio 8)                1555           1571          12          6.7         148.3       8.8X


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

OpenJDK 64-Bit Server VM 25.0.4+7-LTS on Linux 6.17.0-1020-azure
AMD EPYC 9V74 80-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                7539           7568          33          1.4         718.9       1.0X
1K groups, moderate card - optimized                845            855          10         12.4          80.6       8.9X
100K groups, moderate card - baseline             13533          13587          32          0.8        1290.6       0.6X
100K groups, moderate card - optimized             3466           3481          16          3.0         330.5       2.2X
1K groups, low card (5 vals) - baseline            7137           7159          26          1.5         680.6       1.1X
1K groups, low card (5 vals) - optimized            686            698          12         15.3          65.4      11.0X
no grouping key - baseline                         5717           5747          30          1.8         545.2       1.3X
no grouping key - optimized                         293            297           3         35.8          27.9      25.8X


