Community

Maximizing MATCHCOLS when using Simple Subquery (DB2 OS/390 V6)

(Steve Mills) The technique described below is one that I have seen and used many times in recent years (and you may have too) but I have never seen it make quite the impact it did in this scenario. In this instance the addition of a COALESCE function produced a 50% reduction in CPU time and an even

Read More - Register for Free Membership

Tags: