developerWorks: High-Performance SQL

“The past year and a half have seen a lot of DB2 for LUW
activity on the standard TPC-C benchmark, the benchmark commonly
used to measure performance in the on line transaction processing
environment. The results range from the very small numbers on very
reasonable machines to very, big numbers on fantastic setups that
you are unlikely to see at home or at work.

“While the number of rows populating the database schema may
have been adjusted to scale, one area remains the same: SQL. In
this article, you walk through the logic of the TPC-C benchmark,
gain an understanding of the SQL technology, and discover how it
can be used in real customer environments…”

Complete Story