================================================================================================
AS-OF Join Benchmark
================================================================================================

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1022-azure
AMD EPYC 7763 64-Core Processor
AS-OF Join (left=10000, right=10000, groups=100):  Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
--------------------------------------------------------------------------------------------------------------------------------
Correlated subquery (baseline)                            39014          39335         454          0.0     3901384.8       1.0X
Sort-merge AS-OF join                                        49             69          15          0.2        4941.2     789.6X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1022-azure
AMD EPYC 7763 64-Core Processor
AS-OF Join (left=10000, right=10000, groups=10):  Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
-------------------------------------------------------------------------------------------------------------------------------
Correlated subquery (baseline)                           40047          40121         104          0.0     4004730.2       1.0X
Sort-merge AS-OF join                                      120            124           3          0.1       11967.3     334.6X

OpenJDK 64-Bit Server VM 21.0.12+8-LTS on Linux 6.17.0-1022-azure
AMD EPYC 7763 64-Core Processor
AS-OF Join no equi-key (left=10000, right=10000):  Best Time(ms)   Avg Time(ms)   Stdev(ms)    Rate(M/s)   Per Row(ns)   Relative
--------------------------------------------------------------------------------------------------------------------------------
Correlated subquery (baseline)                            23948          24018          99          0.0     2394812.4       1.0X
Sort-merge AS-OF join                                       870            876           7          0.0       86954.2      27.5X


