Advanced SQL and the Power of Rewriting Queries : by Tony Andrews

In recent months the IDUG Content Committee has focused on database performance for DB2 LUW and z/OS.  Performance involves an interaction between database logical and physical design, system tuning and the application coding.  May’s focus is on SQL Performance. 

We opened the month with an article on The Basics of SQL Performance and Performance Tuning by SQL expert (and the head of the IDUG Content Committee) Dan Luksetich.  Dan has been writing and presenting on SQL Performance for many years and you can’t do better than to listen (or read) what he has to say.  Many of you already know the basics, but I’m sure your organizations have many less experienced developers and DBAs.  Be sure to share this article with them and introduce them to all that IDUG has to offer (including the new DB2 Beginner’s Blog).

There are often multiple ways to code a query, some of which perform better than others.  It is not just a matter of effectively utilizing the indexes, but also the SQL constructs.  This week, Tony Andrews of Themis, a popular speaker, author, consultant and trainer is writing on this topic.  His article, Advanced SQL and the Power of Rewriting Queries gives concrete examples of how the way you code can make a big difference.  This is an excellent article.  I’ve used these techniques to solve more SQL performance issues than all other methods combined.  I hope this inspires you to always check your performance and explore simple ways to improve it.

In addition to our new content, I want to remind everyone that last year Sheryl Larsen gave IDUG several of her SQL Tuning presentations to add to our Content Library.  Here are the links:

http://www.idug.org/p/bl/ar/blogaid=155

http://www.idug.org/p/bl/ar/blogaid=157

http://www.idug.org/p/bl/ar/blogaid=162

 If you care about performance (as well as all of DB2’s capabilities), be sure to read these in your leisure (if you don’t have any time, make the time.  It’s worth it).

 

Recent Stories
Lessons Learned of Locking and Latches by Adrian Burke

Db2 for z/OS locking basics

A Beginners Guide to Locks, Latches, Claims and Drains in DB2 for z/OS by Steve Thomas