Chapter 9. Advanced Performance Tuning Tips

In this chapter, we will focus on following recipes related to application performance tuning:

• Understanding predicates in SQL statements

• Improving INSERT performance

• Writing effective SQL statements

Introduction

In this chapter, we will focus on various tips and techniques that can be used to enhance application performance. We will discuss different types of predicates that DB2 considers while compiling an SQL statement. We will also discuss how we can exploit the optimizer using better predicates. Then, we will discuss different ways to improve the INSERT performance. Towards the end, we will talk about many techniques that we can consider while writing better quality SQL statements.