Quantifying TPC-H Choke Points and Their Optimizations
Summary: Systematic analysis of TPC-H choke points; quantifies impact of optimizations across eleven points. Highlights flattening subqueries and predicate placement as most impactful; plan choice drives Q2, Q17, Q21 while engine efficiency dominates Q1, Q13, Q18. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Markus Dreseler (Hasso Plattner Institute; University of Potsdam)
- 2. Martin Boissier (Hasso Plattner Institute; University of Potsdam)
- 3. Tilmann Rabl (Hasso Plattner Institute; University of Potsdam)
- 4. Matthias Uflacker (Hasso Plattner Institute; University of Potsdam)
BibTeX Citation
@article{dreseler_vldb20,
title = {{Quantifying TPC-H Choke Points and Their Optimizations}},
author = {Dreseler, Markus and Boissier, Martin and Rabl, Tilmann and Uflacker, Matthias},
journal = {PVLDB},
series = {{VLDB} '20},
volume = {13},
number = {8},
pages = {1206--1220},
doi = {10.14778/3389133.3389138},
url = {https://doi.org/10.14778/3389133.3389138},
year = {2020}
}Incoming Citations (Sorted by Pagerank)
Showing 31 of 31 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 24 of 24 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 6,108 | Optimization of Conjunctive Predicates for Main Memory Column Stores | 2016 | VLDB |
| 2 | 2,138 | Optimization of Multi-Way Join Queries for Parallel Execution | 1991 | VLDB |
| 3 | 3,362 | Exact Cardinality Query Optimization for Optimizer Testing | 2009 | VLDB |
| 4 | 7,911 | A Practical Approach to Groupjoin and Nested Aggregates | 2021 | VLDB |
| 5 | 9,310 | Rethink Query Optimization in HTAP Databases | 2023 | SIGMOD |
| 6 | 10,144 | How to Optimize SQL Queries? A Comparison Between Split, Holistic, and Hybrid Approaches | 2025 | VLDB |
| 7 | 3,527 | Identifying Robust Plans through Plan Diagram Reduction | 2008 | VLDB |
| 8 | 2,225 | Shared Workload Optimization | 2014 | VLDB |
| 9 | 552 | Orthogonal Optimization of Subqueries and Aggregation | 2001 | SIGMOD |
| 10 | 995 | Analyzing Plan Diagrams of Database Query Optimizers | 2005 | VLDB |