TPC-H Data Vault

Open TPC-H Data Vault in the Results Explorer

TPC-H Data Vault on BenchBox: 18 published runs across 6 platforms. Latest run 2026-10-26.

Platforms

Score definitions

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.01, power

Ranked by geomean query time
RankPlatformVersionRun dateGeomean query timeGeomeanRankingExecution environmentTuning modeTrust label
1ClickHouse Local—2026-10-2635 ms35 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run

SF 0.1, power

Ranked by geomean query time
RankPlatformVersionRun dateGeomean query timeGeomeanRankingExecution environmentTuning modeTrust label
1ClickHouse Local—2026-10-26127 ms127 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run

Runs not included in rankings

16 runs are published with their numbers and receipt but are not ranked. Reason: Known defective data. (16)

Runs excluded from ranking
ScalePhasePlatformVersionRun dateScoreGeomeanReason not rankedExecution environmentTuning modeTrust label
SF 0.01powerBigQuery—2026-09-27979 ms979 msKnown defective data.Cloud, GCP USNo tuningMaintainer Run
SF 0.01powerClickHouse Local—2026-08-2611 ms11 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerDataFusionv53.0.02026-08-258.2 ms8.2 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerDuckDBv1.3.22026-08-265.3 ms5.3 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerBigQuery—2026-09-301.18 s1.18 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
SF 0.1powerClickHouse Local—2026-08-2648 ms48 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerDatabricksv2026.362026-09-301.6 s1.6 sKnown defective data.Cloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
SF 0.1powerDataFusionv53.0.02026-08-2557 ms57 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerDuckDBv1.3.22026-08-2619 ms19 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerSnowflakev10.34.1012026-09-26587 ms587 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
SF 1powerBigQuery—2026-10-013.01 s3.01 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
SF 1powerDatabricksv2026.362026-09-302.06 s2.06 sKnown defective data.Cloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
SF 1powerSnowflakev10.34.1012026-09-25874 ms874 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
SF 10powerBigQuery—2026-10-014.9 s4.9 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
SF 10powerDatabricksv2026.362026-10-016.51 s6.51 sKnown defective data.Cloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
SF 10powerSnowflakev10.35.1012026-09-302.92 s2.92 sKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run