TPC-D Query Set
17 queries written in SQL92 to implement business questions.
Queries are pseudo ad hoc:
- Substitution parameters are replaced with constants by QGEN
- QGEN replaces substitution parameters with random values
- No host variables
- No static SQL
Queries cannot be modified -- “SQL as written”
- There are some minor exceptions.
- All variants must be approved in advance by the TPC