Articles & Content


E10 - Query optimization in Relational Databases – what’s the big deal?

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2014

From the early days of SQL, we have advertised that the user specifies the “what” without worrying about the “how” - query optimization takes care of that.
A lot has changed since the early days of RDBMS. SQL 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 glimpse into some of the challenges and how some of the leading RDBMS (DB2, Oracle, SQL Server) are addressing them. We will discuss what the future of query optimization may look like and why “perfect” may not be attainable.

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.