| ================================================================================================ |
| SQL Single Numeric Column Scan |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| SQL Single TINYINT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Sum 3468 3495 39 4.5 220.5 1.0X |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| SQL Single SMALLINT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Sum 3378 3388 13 4.7 214.8 1.0X |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| SQL Single INT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Sum 3353 3371 26 4.7 213.2 1.0X |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| SQL Single BIGINT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Sum 3712 3739 38 4.2 236.0 1.0X |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| SQL Single FLOAT Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Sum 3290 3322 45 4.8 209.2 1.0X |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| SQL Single DOUBLE Column Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Sum 3475 3493 25 4.5 220.9 1.0X |
| |
| |
| ================================================================================================ |
| Int and String Scan |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Int and String Scan: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Sum of columns 5032 5053 29 2.1 479.9 1.0X |
| |
| |
| ================================================================================================ |
| Partitioned Table Scan |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Partitioned Table: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Data column 3819 3820 1 4.1 242.8 1.0X |
| Partition column 3285 3340 77 4.8 208.8 1.2X |
| Both columns 4051 4066 21 3.9 257.6 0.9X |
| |
| |
| ================================================================================================ |
| Repeated String Scan |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Repeated String: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Sum of string length 3631 3653 32 2.9 346.2 1.0X |
| |
| |
| ================================================================================================ |
| String with Nulls Scan |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| String with Nulls Scan (0.0%): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Sum of string length 5786 5801 21 1.8 551.8 1.0X |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| String with Nulls Scan (50.0%): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Sum of string length 3767 3791 34 2.8 359.2 1.0X |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| String with Nulls Scan (95.0%): Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Sum of string length 2472 2498 36 4.2 235.8 1.0X |
| |
| |
| ================================================================================================ |
| Single Column Scan From Wide Columns |
| ================================================================================================ |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Single Column Scan from 100 columns: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Sum of single column 5366 5366 0 0.2 5117.5 1.0X |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Single Column Scan from 200 columns: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Sum of single column 10223 10234 15 0.1 9749.7 1.0X |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Single Column Scan from 300 columns: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| Sum of single column 15283 15328 64 0.1 14575.0 1.0X |
| |
| |
| OpenJDK 64-Bit Server VM 11.0.10+9-LTS on Linux 5.4.0-1043-azure |
| Intel(R) Xeon(R) Platinum 8171M CPU @ 2.60GHz |
| Filters pushdown: Best Time(ms) Avg Time(ms) Stdev(ms) Rate(M/s) Per Row(ns) Relative |
| ------------------------------------------------------------------------------------------------------------------------ |
| w/o filters 9724 9765 46 0.1 9724.4 1.0X |
| pushdown disabled 9628 9726 99 0.1 9627.6 1.0X |
| w/ filters 4833 4879 40 0.2 4833.5 2.0X |
| |