Motivation
Remember the days when DB2 re-entered the TPC-C fight after a long hiatus? The time was DB2 8.1 FP4. I seriously do not remember years.. Time passes in releases. While my colleagues were tuning code path, bufferpools disks my team was looking at something more fundamental. What can we do to make SQL as efficient as possible for TPC-C. And ideally how can we make SQL more efficient for any class of OLTP workload. In other words how can we pour the most bang into the least SQL for a typical OLTP transaction? The result was what we...
[More]
Tags:
table
return
transition
from
insert
select
new
old
order
call
final
delete
processing
update
with
X
Interesting SQL solutions for DB2 LUW as well as hints on how to move Oracle applications to DB2
