| ================================================================================================ |
| Top-K Computation |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 17.0.16+8-LTS on Linux 6.11.0-1018-azure |
| AMD EPYC 7763 64-Core Processor |
| Benchmark Top-K: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ----------------------------------------------------------------------------------------------------------------------------------------------- |
| ROW_NUMBER (PARTITION: , WindowGroupLimit: false) 9226 9344 163 2.3 439.9 1.0X |
| ROW_NUMBER (PARTITION: , WindowGroupLimit: true) 1714 1729 12 12.2 81.7 5.4X |
| ROW_NUMBER (PARTITION: PARTITION BY b, WindowGroupLimit: false) 11871 11990 74 1.8 566.1 0.8X |
| ROW_NUMBER (PARTITION: PARTITION BY b, WindowGroupLimit: true) 5203 5264 34 4.0 248.1 1.8X |
| RANK (PARTITION: , WindowGroupLimit: false) 9775 9833 63 2.1 466.1 0.9X |
| RANK (PARTITION: , WindowGroupLimit: true) 2080 2125 29 10.1 99.2 4.4X |
| RANK (PARTITION: PARTITION BY b, WindowGroupLimit: false) 12384 12445 40 1.7 590.5 0.7X |
| RANK (PARTITION: PARTITION BY b, WindowGroupLimit: true) 5224 5281 43 4.0 249.1 1.8X |
| DENSE_RANK (PARTITION: , WindowGroupLimit: false) 9688 9760 53 2.2 462.0 1.0X |
| DENSE_RANK (PARTITION: , WindowGroupLimit: true) 2081 2130 39 10.1 99.3 4.4X |
| DENSE_RANK (PARTITION: PARTITION BY b, WindowGroupLimit: false) 12331 12407 45 1.7 588.0 0.7X |
| DENSE_RANK (PARTITION: PARTITION BY b, WindowGroupLimit: true) 5288 5358 100 4.0 252.1 1.7X |
| |
| |
