The Leading Educational Resource for IT Professionals

TechTip: DB2 for i Optimization Strategies, Part 5


Learn how to take an ax to common suboptimal SQL programming practices.

Written by Mike Sansoterra

This series is almost done, yet there are so many illustrations of potential code improvements to offer to the DB2 for i development community. This tip discusses possible performance improvements when replacing legacy cursors with set operations and when using temporary tables. See the references at the end of this tip for links to prior tips in this series.

Continue Reading →