Good information thanks! I work with A LOT of old code and I hate seeing it, but I digress.
You might alread know this but there are possible ways to speed up your DB2 queries even more. The iSeries (System i is just the current name which I'm sure is subject to change at any time) has 2 query engines. The SQE and the CQE. The SQE is the SQL Query Engine and the CQE is the Classic Query Engine. Here is an short arcticle about how to change an attribute so that your SQL will most likey use the SQE. http://www.itjungle.com/fhg/fhg041608-story01.html -- James R. Perkins On Fri, May 1, 2009 at 11:29, ericdrum <ericdr...@gmail.com> wrote: > > I work at a place that uses both Oracle and DB2. Our DB2 is on an > iSeries, AS/400, System i or whatever IBM wants to call it. I will say > that we write some very gnarly queries that DB2 eats for lunch. I'm > seriously impressed by it at times because we will have the worst join > conditions over 20 tables (due to using tables that were created in > 70s with terrible design) that should just be dog slow and DB2 handles > it very well. If we are talking new functionality with new tables, the > thing simply screams. Whenever we bring on people that have Oracle > backgrounds, they are quickly impressed by the speed of DB2's queries. > I don't know how much the iSeries plays into that, but it's worth > mentioning. > > @James, IMO, Oracle is much more bloated and acts like an OS. It takes > over the machine. It's still very powerful and flexible and a good > solution for many, but when we have tried some tables that are in DB2 > with many millions of records in them, inside of Oracle, we got less > performance. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "The Java Posse" group. To post to this group, send email to javaposse@googlegroups.com To unsubscribe from this group, send email to javaposse+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/javaposse?hl=en -~----------~----~----~----~------~----~------~--~---
