TPC-DS

Open TPC-DS in the Results Explorer

TPC-DS on BenchBox: 37 published runs across 10 platforms. Latest run 2026-10-26.

Platforms

Score definitions

Power score
Power@Size: scale factor × 3600 divided by the geometric mean of the query times of the final iteration, in seconds. Unit: queries per hour at scale factor size; higher is better. Definition in the benchmark methodology.
Geomean query time
Geometric mean of the displayed per-query times of the run. Unit: milliseconds, shown as seconds from 1,000 ms; lower is better. Definition in the benchmark methodology.

SF 0.1, power

Ranked by power score
RankPlatformVersionRun datePower scoreGeomeanRankingExecution environmentTuning modeTrust label
1BigQuery—2026-09-20435.8833 msRankedCloud, GCP USNo tuningMaintainer Run
2Snowflakev10.35.1012026-10-03341.8856 msRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
3Databricksv2026.362026-10-03305.91.08 sRankedCloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run

SF 1, power

Ranked by power score
RankPlatformVersionRun datePower scoreGeomeanRankingExecution environmentTuning modeTrust label
1DuckDBv1.3.22026-08-23269,80313 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
2DuckDBv1.5.52026-10-01114,64932 msRankedLocal, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
3DuckDBv1.3.22026-09-0179,63945 msRankedLocal, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
4Sparkv4.1.12026-08-236,211557 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
5Snowflakev10.35.1012026-10-033,709974 msRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
6Databricksv2026.362026-10-032,7651.35 sRankedCloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run

SF 10, power

Ranked by power score
RankPlatformVersionRun datePower scoreGeomeanRankingExecution environmentTuning modeTrust label
1DuckDBv1.3.22026-08-23497,999105 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
2Snowflakev10.35.1012026-10-0328,9181.21 sRankedCloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
3Databricksv2026.362026-10-0321,1761.7 sRankedCloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run

Runs not included in rankings

25 runs are published with their numbers and receipt but are not ranked. Reason: Non-standard runs are unofficial and are not ranked. (17); Known defective data. (7); One or more queries failed. (1)

Runs excluded from ranking
ScalePhasePlatformVersionRun dateScoreGeomeanReason not rankedExecution environmentTuning modeTrust label
SF 1powerBigQuery—2026-09-20—943 msNon-standard runs are unofficial and are not ranked.Cloud, GCP USNo tuningMaintainer Run
SF 1powerClickHouse Local—2026-10-0135,78294 msKnown defective data.Local, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
SF 1powerClickHouse Local—2026-08-26—59 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerClickHouse Local—2026-10-26—190 msNon-standard runs are unofficial and are not ranked.Local, Arm64, 9.8 GBNo tuningMaintainer Run
SF 1powerDataFusionv53.0.02026-09-0126,925134 msKnown defective data.Local, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
SF 1powerDataFusionv54.0.02026-10-0139,96790 msKnown defective data.Local, x86-64, Intel Xeon, 15.6 GBNo tuningMaintainer Run
SF 1powerDataFusionv53.0.02026-08-2372,79450 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerDataFusionv53.0.02026-08-26—52 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerDataFusionv54.0.02026-10-26—46 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
SF 1powerDuckDBv1.3.22026-08-25—12 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerPandasv2.3.32026-08-26—676 msNon-standard runs are unofficial and are not ranked.Local, Apple siliconNo tuningMaintainer Run
SF 1powerPolarsv1.40.02026-08-26—40 msNon-standard runs are unofficial and are not ranked.Local, Apple siliconNo tuningMaintainer Run
SF 1powerSparkv4.1.12026-08-26—509 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerSQLitev3.53.12026-08-24—8.69 sNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerBigQuery—2026-09-20—1.7 sNon-standard runs are unofficial and are not ranked.Cloud, GCP USNo tuningMaintainer Run
SF 10powerDataFusionv53.0.02026-08-23151,089237 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDataFusionv54.0.02026-10-26—438 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
SF 10powerDuckDBv1.0.02026-08-29—92 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv1.1.32026-08-29—63 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv1.2.22026-08-29—71 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv1.3.22026-08-29—68 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv1.4.42026-08-29—62 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv1.5.52026-08-29—54 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv2.0.0-alpha386152026-08-29—46 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerSparkv4.1.12026-08-23—2.25 sOne or more queries failed.Local, Arm64, Apple siliconNo tuningMaintainer Run