Applied spiff Bottleneck addressed TPCH 10G
Query execution
time
(second)
Cumulative
Improvement
(over stock)
table
instruction execution
22.2 5%
table
hash join
instruction execution
memory access
13.9 41%
table
hash join
predicate
aggregate
instruction execution
memory access
12.7 46%