Applied spiff Bottleneck addressed TPCH 1G
Query execution
time
(millisecond)
Cumulative
Improvement
(over stock)
table
instruction execution
1680 7%
table
hash join
instruction execution
memory access
1250 31%
table
hash join
predicate
aggregate
instruction execution
memory access
1125 38%