Introduction to TPC-D, TPC-R, and TPC-H

The decision-support benchmark—TPC-D—originally released by the TPC has been superseded by two new benchmarks: TPC-H and TPC-R. Since the new benchmarks have their roots in TPC-D, all three are worth discussing.


The TPC-D V1 workload simulated a decision-support environment, specifically, a warehouse-based distribution operation. It comprised 17 complex queries and small-scale business data updates (inserts and deletes).

A TPC-D benchmark consisted of a timed database load, a power run, and a throughput run. The power run was a sequence comprising the first update function (data insertion), the 17 queries, and the second update function (data deletion). The throughput run comprised a vendor-selectable ...

Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.