| TPC-D definition requires that either one (power test) or many (scale-up test) query streams are run and timed against at least three sizes of a predefined database, with sizes growing exponentially (e.g., 1G, 10GB, 100GB sequence) |
| Query stream consists of 17 complex queries plus two concurrently running update operations |
| No extensive database tuning in allowed - optimizer hints are explicitly forbidden |
| timings for individual queries are not part of the TPC-D metric |
| Database structure well represents most common DSS DBs in applications, i.e. one largest table takes ~70% of the total DB size. |