Articles & Content


The perfect access path? Evolution of the DB2 Optimizer - E04

Topic: 2012 NA

Subtopic: DB2 for z/OS

SQL is a declarative language - the user specifies the “what” . It is up to the DB2 Optimizer to analyze the access path choices and determine the “how”.

A lot has changed since the early days of DB2. The language has grown. The queries are more complex. The amount of data has grown exponentially and the service level expectations have become tighter. What was good then is simply not acceptable today.

In this session, we will provide a historical context for the challenges faced by query optimization and discuss why “perfect” may not be attainable and what the future of query optimization may look like.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.