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:
http://www.redbooks.ibm.com/abstracts/sg246598.html?Open
Search on "benchmark".
Elvis
Mike Cain - DB2 for i5/OS Temporary Indexes - The Good, The Bad, The Ugly
October 16
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
-----Original Message-----
Subject: RE: Why buy 5733-Qu2 (Was: 5733QU2 - No Developer Discount)
Right on Pete. SQE rocks.
Michael Crump
-----Original Message-----
Subject: Why buy 5733-Qu2 (Was: 5733QU2 - No Developer Discount)
<snip>
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,
and
it is definitely worth it. I have never seen anything this good on the
AS/400, iSeries, or i5.
Pete
</snip>
As an Amazon Associate we earn from qualifying purchases.