by Adarsh Pannu, IBM (US)

Audience: Application developer, DB2 DBA, Level: Basic, Intermediate

Link to the presentation S131. DB2 developers guide to optimum Performance

The performance of business-critical applications often depends on SQL queries in the workload. Given the declarative nature of SQL, there is usually more than one way to obtain the same information from DB2. Some of these query variants can be dramatically more (or less) efficient than others. As you develop new applications, it is important to be aware of efficient SQL programming techniques to ensure optimum performance. This session outlines some of thesetechniques and also lists potential pitfalls to avoid.

Adarsh Pannu is a Senior Technical Staff Member on the DB2 for z/OS development team. He has over two decades of experience developing database management systems, primarily focusing on query optimization and execution.