================================================================================================
Join Benchmark
================================================================================================

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
INTEL(R) XEON(R) PLATINUM 8573C
Join w long:                              Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Join w long wholestage off                         1771           1813          59         11.8          84.4       1.0X
Join w long wholestage on                          1004           1012          12         20.9          47.9       1.8X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
INTEL(R) XEON(R) PLATINUM 8573C
Join w long duplicated:                   Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Join w long duplicated wholestage off              1375           1401          37         15.3          65.6       1.0X
Join w long duplicated wholestage on                745            751           6         28.2          35.5       1.8X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
INTEL(R) XEON(R) PLATINUM 8573C
Join w 2 ints:                            Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Join w 2 ints wholestage off                     157403         157614         299          0.1        7505.5       1.0X
Join w 2 ints wholestage on                      144961         145997         953          0.1        6912.3       1.1X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
INTEL(R) XEON(R) PLATINUM 8573C
Join w 2 longs:                           Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Join w 2 longs wholestage off                      2853           2869          23          7.3         136.1       1.0X
Join w 2 longs wholestage on                       2247           2287          26          9.3         107.2       1.3X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
INTEL(R) XEON(R) PLATINUM 8573C
Join w 2 longs duplicated:                Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
Join w 2 longs duplicated wholestage off           5804           5837          48          3.6         276.7       1.0X
Join w 2 longs duplicated wholestage on            4314           4356          30          4.9         205.7       1.3X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
INTEL(R) XEON(R) PLATINUM 8573C
outer join w long:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
outer join w long wholestage off                   1403           1455          74         14.9          66.9       1.0X
outer join w long wholestage on                    1084           1093           8         19.4          51.7       1.3X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
INTEL(R) XEON(R) PLATINUM 8573C
semi join w long:                         Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
semi join w long wholestage off                     805            810           6         26.0          38.4       1.0X
semi join w long wholestage on                      425            430           4         49.4          20.2       1.9X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
INTEL(R) XEON(R) PLATINUM 8573C
sort merge join:                          Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
sort merge join wholestage off                     1000           1001           1          2.1         477.0       1.0X
sort merge join wholestage on                       929            973          40          2.3         442.9       1.1X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
INTEL(R) XEON(R) PLATINUM 8573C
sort merge join with duplicates:                Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------------
sort merge join with duplicates wholestage off           1390           1404          20          1.5         662.8       1.0X
sort merge join with duplicates wholestage on            1343           1368          22          1.6         640.5       1.0X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
INTEL(R) XEON(R) PLATINUM 8573C
shuffle hash join:                        Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
------------------------------------------------------------------------------------------------------------------------
shuffle hash join wholestage off                    437            439           4          9.6         104.1       1.0X
shuffle hash join wholestage on                     373            380           5         11.2          88.9       1.2X

OpenJDK 64-Bit Server VM 17.0.20+8-LTS on Linux 6.17.0-1020-azure
INTEL(R) XEON(R) PLATINUM 8573C
broadcast nested loop join:                Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
-------------------------------------------------------------------------------------------------------------------------
broadcast nested loop join wholestage off          21693          21721          41          1.0        1034.4       1.0X
broadcast nested loop join wholestage on           21575          21731         144          1.0        1028.8       1.0X


