The Leading Educational Resource for IT Professionals

MC Press Articles

Mike Sansoterra

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 →

About us

MC Press Online, LLC is the world's leading provider of educational materials for IBM Power Systems (System i, eServer i5/iSeries, and AS/400) professionals. Our mission is to deliver hands-on, nuts-and-bolts information about current and significant new technologies in the IBM field, so you can be more productive on the job and get more out of your career.

MC Press offers books, ebooks, and electronic publications that take you inside the technology, so you can find out how to best leverage the power and potential of your IBM platforms. Our books cover a wide range of topics--from hands-on, how-to programming to the most advanced communications, connectivity, and security issues facing the industry today.

For the latest news, analysis, in-depth technical articles, programming code, case studies, product reviews, and much more delivered to your email inbox, take a look at our free electronic publications: Online Newsletters.

To pick up valuable tips from your peers, check out the MC Press Forums, and don't forget about our MC Press Buyer's Guide, where you can find computing and technology solutions for all your IT needs.