Preface

Most relational tuning experts agree that the majority of performance problems among applications that access a relational database are caused by poorly coded programs or improperly coded SQL. Industry experts also note that poor performing SQL is responsible for as much as 80 percent of response-time issues. I personally agree with this. Of all the IT shops for which I have provided performance and tuning consulting work in, most of the performance issues are directly related to modifying application and SQL code, or adding and altering indexes. That is why I continually try to educate developers in the ways of SQL programming and associated performance issues. I also believe more developers should be educated in how to read and analyze ...

Get DB2 SQL Tuning Tips for z/OS Developers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.