Topics:

• Optimizing Requests
• Optimization Logic
• Optimizing Record Selection and Projection
• Optimizing Joins
• Optimizing Sorts
• Optimizing Aggregation
• Optimizing DEFINE Fields
• DEFINE FUNCTION Optimization
• Optimizing Function Calls
• The FOCUS EXPLAIN Utility (DB2 and Teradata)

Optimization is the process in which the adapter translates the projection, selection, join, sort, and aggregation operations of a report request into their SQL equivalents and passes them to the RDBMS for processing.