The Data Adapter Optimizer

Topics: Optimizing Requests Optimization Logic Optimizing Record Selection and Projection Optimizing Joins Optimizing Sorts Optimizing Aggregation Optimizing DEFINE Fields The FOCUS EXPLAIN Utility (DB2 and Teradata)

Optimization is the process in which the data 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.