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 ...
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.
