TPC-H SF1 Benchmark Results
All 22 TPC-H queries pass correctness validation at Scale Factor 1 (~1GB dataset).
Test environment: 36 cores (18C/36T), 64GB RAM, NVMe storage, Linux.
Results Summary
22/22 queries passing ✅
| Query | Description | Time (ms) | Rows |
|---|---|---|---|
| Q1 | Pricing Summary Report | 151 | 4 |
| Q2 | Minimum Cost Supplier | 194 | 100 |
| Q3 | Shipping Priority | 209 | 10 |
| Q4 | Order Priority Checking | 1,052 | 5 |
| Q5 | Local Supplier Volume | 242 | 5 |
| Q6 | Forecasting Revenue Change | 203 | 1 |
| Q7 | Volume Shipping | 1,185 | 4 |
| Q8 | National Market Share | 489 | 2 |
| Q9 | Product Type Profit | 1,401 | 175 |
| Q10 | Returned Item Reporting | 255 | 20 |
| Q11 | Important Stock ID | 93 | 1,048 |
| Q12 | Shipping Modes | 658 | 2 |
| Q13 | Customer Distribution | 1,469 | 42 |
| Q14 | Promotion Effect | 72 | 1 |
| Q15 | Top Supplier | 191 | 1 |
| Q16 | Parts/Supplier Relationship | 146 | 18,314 |
| Q17 | Small-Quantity-Order Revenue | 1,484 | 1 |
| Q18 | Large Volume Customer | 851 | 57 |
| Q19 | Discounted Revenue | 9,090 | 1 |
| Q20 | Potential Part Promotion | 1,803 | 186 |
| Q21 | Suppliers Who Kept Orders Waiting | 3,251 | 100 |
| Q22 | Global Sales Opportunity | 925 | 7 |