O'Reilly logo

DB2 SQL Tuning Tips for z/OS Developers by Tony Andrews

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 1. SQL Optimization Top 100+

The following are some of the most effective things developers can do in their SQL code to ensure better performance. 90% of the runtime problems in a relational database management systems (RDBMS) typically comes from 10% of application issues. Today’s DB2® optimizer is better than ever at selecting the correct access paths to fulfill SQL requests, but it can never be 100% correct. All tuning efforts are directly related to CPU usage, I/O, and concurrency. Most of the topics in this chapter are specific to SQL coding, but all topics are related to performance and tuning.

The hints presented in this book are general best practices for developers that apply to most RDBMSs. Cost-based optimizers in these database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required