phacai.com

For those who didn’t know, DBT2 is an implementation of TPCC benchmark. Following is a list of tables and indexes created:

Tables          |              Indexes
customer (0)
                       pk_customer (1), i_customer (2)
district (3)
                       pk_district (4)
history (5)
item (6)
                       pk_item (7)
new_order (0)
                       pk_new_order (1)
order_line (2)
                       pk_order_line (3)
orders (4)
                       pk_orders (5), i_orders (6)
stock (7)
                       pk_stock (0)
warehouse (1)
                       pk_warehouse (2)

Totally 19 (8+8+3) ones.

Mr. One Database