Its a SQL tour through the DB2 TPC-C benchmark implementation. This article introduces advanced SQL features which are being used in IBM DB2 Universal Database for Linux, UNIX, and Windows TPC-C benchmarks. Find out how to use efficient SQL query plans, which in turn will mean that the only codepath that is necessary will be executed.
Looking at the code, it looks like most of this code and new functionality was created to optimize the throughput for this benchmark. Kudos to the team for writng the database to optimize to run a benchmark.
> Looking at the code, it looks like most of this code and new functionality was created to optimize the throughput for this benchmark.
You’re a funny guy. Of course the code is optimized for the benchmark! That’s because it is in fact, the benchmark code.