Three consecutive executions per query. Execution 3 is the main result. Caching allowed.
52 queries · 52 main results · seconds · execution 3 is the main result
| Query / plan | Run 1 · warmup | Run 2 · warmup | Run 3 · main | Run 3 · server |
|---|---|---|---|---|
| Q001 | 1.65 | 0.47 | 0.45 | 0.45 |
| Q010 | 2.33 | 0.34 | 0.36 | 0.35 |
| Q013 | 1.55 | 0.42 | 0.41 | 0.41 |
| Q013 SPJ | 0.41 | 0.41 | 0.42 | 0.42 |
| Q014Demo | 4.09 | 2.66 | 2.11 | 2.11 |
| Q018 | 1.39 | 0.31 | 0.32 | 0.32 |
| Q018 SPJ | 0.24 | 0.22 | 0.22 | 0.22 |
| Q019 | 0.61 | 0.19 | 0.18 | 0.17 |
| Q019 SPJ | 0.17 | 0.17 | 0.17 | 0.16 |
| Q023 | 4.16 | 1.92 | 2.22 | 2.22 |
| Q025 | 1.82 | 0.65 | 0.65 | 0.65 |
| Q025 SPJ | 1.40 | 0.52 | 0.52 | 0.51 |
| Q027 | 0.90 | 0.21 | 0.22 | 0.21 |
| Q027 SPJ | 0.31 | 0.16 | 0.17 | 0.16 |
| Q030 | 1.31 | 0.35 | 0.37 | 0.36 |
| Q031 | 3.25 | 3.03 | 2.86 | 2.86 |
| Q032 | 0.49 | 0.24 | 0.24 | 0.23 |
| Q038 | 1.10 | 0.55 | 0.55 | 0.55 |
| Q039 | 0.80 | 0.45 | 0.45 | Unavailable |
| Q040 | 0.79 | 0.20 | 0.27 | 0.27 |
| Q040 SPJ | 0.31 | 0.26 | 0.18 | 0.18 |
| Q050 | 1.46 | 0.50 | 0.51 | 0.51 |
| Q050 SPJ | 0.41 | 0.42 | 0.41 | 0.41 |
| Q054 | 0.98 | 0.64 | 0.64 | 0.64 |
| Q058 | 0.86 | 0.43 | 0.43 | 0.43 |
| Q059 | 1.76 | 1.60 | 1.54 | 1.54 |
| Q064 | 6.45 | 5.90 | 6.24 | 6.24 |
| Q065 | 0.81 | 0.31 | 0.31 | 0.30 |
| Q069 | 0.83 | 0.38 | 0.38 | 0.38 |
| Q072 | 1.70 | 0.77 | 0.77 | 0.77 |
| Q072 SPJ | 0.59 | 0.58 | 0.59 | 0.59 |
| Q075 | 3.91 | 3.10 | 3.12 | 3.12 |
| Q080 | 1.78 | 0.42 | 0.42 | 0.42 |
| Q081 | 1.33 | 0.98 | 0.98 | 0.98 |
| Q083 | 0.62 | 0.29 | 0.29 | 0.29 |
| Q084 | 0.68 | 0.45 | 0.46 | 0.45 |
| Q084 SPJ | 0.63 | 0.47 | 0.47 | 0.47 |
| Q085 | 1.01 | 0.39 | 0.38 | 0.38 |
| Q085 SPJ | 0.37 | 0.37 | 0.38 | 0.38 |
| Q087 | 0.93 | 0.45 | 0.32 | 0.32 |
| Q091 | 0.47 | 0.22 | 0.22 | 0.21 |
| Q091 SPJ | 0.29 | 0.20 | 0.21 | 0.21 |
| Q092 | 0.48 | 0.30 | 0.33 | 0.32 |
| Q094 | 0.47 | 0.24 | 0.24 | 0.24 |
| Q099 | 0.47 | 0.18 | 0.18 | 0.18 |
| Q099 SPJ | 0.28 | 0.16 | 0.16 | 0.16 |
| Q100 | 0.61 | 0.51 | 0.52 | 0.50 |
| Q100 SPJ | 0.49 | 0.49 | 0.49 | 0.49 |
| Q101 | 1.23 | 0.85 | 0.87 | 0.87 |
| Q101 SPJ | 0.87 | 0.82 | 0.81 | 0.81 |
| Q102 | 11.02 | 10.23 | 9.10 | 9.09 |
| Q102 SPJ | 8.74 | 9.69 | 9.33 | 9.33 |
Main results (JSON) · All three executions and cache telemetry (JSON)
Fabric Data Warehouse · F64 · CPU · West Europe · SF100. Dedicated capacity: f64polaris2026. One SQL pool: Sql pool1 · 100% compute · Optimize for reads.
177 queries: TPC-H 22, TPC-DS 103 query parts, DSB 52 fixed instances. One user executes the catalogue once. Each query runs three times consecutively, with caching allowed. Execution 3 is the main result. Executions 1 and 2 warm the caches and remain available for comparison.
Client response time covers execution and complete result transfer. SQL connection setup and Warehouse data loading precede measurement. All inputs are managed Warehouse tables. Results preserve errors and all three attempts.
Query Insights supplies separate server times and OneLake, RAM and SSD scan volumes. Rows match the distributed statement ID captured during execution. DSB query 039 contains two SQL statements per execution; its client time covers both statements and result sets. Its server telemetry is unavailable because the captured statement ID is ambiguous. Unavailable telemetry is marked explicitly. Result cache: 0 = unused, 1 = entry created, 2 = hit. Caching is allowed; actual reuse depends on each query.
Plans are saved estimated Warehouse plans. They show operator structure and optimiser estimates. Data caching · Result-set caching · Query Insights
Run 0973a214-8d95-4fff-839a-997efda1ae51 · 531 / 531 successful executions · 1044.2 s measurement window · Published 2026-10-04T21:34:14.384Z