My non-scientific observation is that SQE performs better in most cases
(high 90s percentile). In a lot of cases many orders of magnitude better.
Rather then rely on my observations, take a peek at "Preparing for and
Tuning the SQL Query Engine on DB2 for i5/OS" redbook:
Search on "benchmark".
Mike Cain - DB2 for i5/OS Temporary Indexes - The Good, The Bad, The Ugly
2007 System i Fall Technical Conference | Orlando | November 4-7
Celebrating 10-Years of SQL Performance Excellence on IBM System i, eServer
iSeries and the server affectionately known as the AS/400
Subject: RE: Why buy 5733-Qu2 (Was: 5733QU2 - No Developer Discount)
Right on Pete. SQE rocks.
Subject: Why buy 5733-Qu2 (Was: 5733QU2 - No Developer Discount)
See how existing queries even run better. I bet our resident SQL expert
Elvis can tell us how much better the SQE engine is over the CQE engine, and
guess which one QU2 uses, and guess which one QU1 uses.
You can tell I am excited about this, as I have played with it,
it is definitely worth it. I have never seen anything this good on the
AS/400, iSeries, or i5.