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

Previous slide

Next slide

Back to first slide

View graphic version