TPC-DS benchmark results

Query / plan	Run 1 · warmup	Run 2 · warmup	Run 3 · main	Run 3 · server
Q1	0.46	0.10	0.10	0.10
Q2	1.89	1.52	1.49	1.47
Q3	0.93	0.72	0.75	0.75
Q4Demo	10.27	9.09	10.64	10.63
Q5	1.79	0.73	0.74	0.73
Q6	0.86	0.57	0.58	0.58
Q7	2.29	1.43	1.42	1.42
Q8	1.45	1.44	1.40	1.39
Q9	4.80	1.66	0.90	0.90
Q10	2.40	0.70	0.71	0.71
Q11	11.05	13.59	8.72	8.72
Q12	1.20	0.71	0.71	0.71
Q13	3.53	1.11	1.11	1.11
Q14A	9.23	10.14	4.60	4.59
Q14B	5.16	4.83	4.16	4.15
Q15	2.15	1.32	1.31	1.30
Q16	0.76	0.22	0.22	0.21
Q17	3.80	1.79	1.82	1.81
Q18	1.42	0.88	0.88	0.88
Q19	1.22	0.52	0.53	0.53
Q20	0.54	0.39	0.39	0.39
Q21	0.81	0.46	0.45	0.45
Q22	7.42	6.91	6.86	6.86
Q23A	11.09	9.44	6.91	6.91
Q23B	8.63	6.82	6.80	6.80
Q24A	4.11	1.78	1.80	1.80
Q24B	1.76	1.91	1.82	1.82
Q25	2.55	1.33	1.31	1.31
Q26	0.91	0.41	0.41	0.40
Q27	2.43	1.44	1.43	1.43
Q28	6.16	2.10	1.32	1.32
Q29	4.63	1.53	1.53	1.53
Q30	1.80	1.03	1.03	1.03
Q31	2.67	1.68	1.65	1.64
Q32	0.39	0.15	0.16	0.15
Q33	1.25	0.86	0.85	0.85
Q34	1.07	0.75	0.74	0.72
Q35	2.34	1.74	1.68	1.68
Q36	1.65	1.37	1.36	1.35
Q37	0.84	0.26	0.26	0.26
Q38	3.32	3.19	3.20	3.20
Q39A	2.98	1.95	1.92	1.91
Q39B	1.60	1.66	1.53	1.53
Q40	0.55	0.24	0.24	0.23
Q41	0.21	0.12	0.11	0.11
Q42	0.67	0.64	0.64	0.63
Q43	0.12	0.08	0.08	0.08
Q44	0.48	0.18	0.18	0.17
Q45	2.11	1.86	1.87	1.87
Q46	1.84	1.59	1.60	1.60
Q47	7.74	4.17	4.29	4.29
Q48	3.79	1.60	1.60	1.60
Q49	3.10	0.78	0.80	0.80
Q50	2.25	1.87	1.92	1.91
Q51	7.25	8.37	6.28	6.28
Q52	0.73	0.64	0.65	0.65
Q53	1.05	0.91	0.90	0.90
Q54	1.10	0.74	0.74	0.74
Q55	0.61	0.61	0.61	0.61
Q56	1.31	0.96	0.95	0.95
Q57	3.93	3.38	2.80	2.79
Q58	0.85	0.76	3.21	3.21
Q59	4.63	3.35	3.34	3.34
Q60	1.67	1.07	1.07	1.07
Q61	2.14	1.12	1.12	1.12
Q62	1.41	1.11	1.12	1.12
Q63	1.06	0.84	0.84	0.84
Q64Demo	5.46	3.96	3.59	3.59
Q65	1.72	1.60	1.59	1.58
Q66	1.43	0.92	0.92	0.92
Q67	22.27	19.00	19.08	19.08
Q68	0.30	0.15	0.15	0.15
Q69	0.90	0.77	0.80	0.79
Q70	1.89	1.84	1.84	1.84
Q71	1.61	0.94	1.04	0.75
Q72	3.04	2.47	2.28	2.28
Q73	0.80	0.56	0.53	0.52
Q74	9.77	9.12	9.09	9.09
Q75	4.36	3.38	3.22	3.21
Q76	1.04	0.73	0.73	0.73
Q77	1.58	0.72	0.71	0.71
Q78	4.85	3.69	3.62	3.62
Q79	6.11	1.38	1.41	1.41
Q80	2.81	0.88	0.90	0.89
Q81	0.98	0.55	0.55	0.55
Q82	0.89	0.65	0.66	0.66
Q83	0.83	0.61	0.61	0.61
Q84	0.40	0.29	0.28	0.28
Q85	1.25	0.84	0.87	0.86
Q86	3.04	2.35	2.41	2.41
Q87	2.89	2.84	2.93	2.93
Q88	2.63	1.25	1.32	1.32
Q89	1.16	1.17	1.15	1.15
Q90	0.65	0.41	0.41	0.41
Q91	0.37	0.22	0.23	0.22
Q92	0.78	0.69	0.61	0.60
Q93	1.86	1.80	1.83	1.83
Q94	1.41	0.74	0.73	0.73
Q95	0.71	0.31	0.32	0.32
Q96	0.67	0.41	0.41	0.41
Q97	3.15	3.00	3.05	3.04
Q98	1.41	1.30	1.28	1.09
Q99	1.13	0.95	0.92	0.92

Cached sequential measurement

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