Articles & Content

Archives

Query Optimization Fundamentals - All About Sort (B04)

Topic: DB2 for LUW

Subtopic: 2011



This is a back to basics presentation. It describes the architecture of the sort and aggregation algorithms that currently exist in DB2. It covers how the DB2 optimizer decides to use sorts to benefit various other operations even though the query may not seem like it needs a sort of the intermediate data streams. You will also learn what is different in the Database Partitioned Feature (DPF) environment when dealing with sort and aggregation. Windows aggregation and its usage in interesting queries will also be discussed.



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.