Optimization means passing the following tasks to the RDBMS:
Aside from record selection and projection, the adapter does not offload these functions to the RDBMS if you set OPTIMIZATION to OFF. When OPTIMIZATION is not OFF, the adapter evaluates each report request for the existence of joins, sort operations, and finally aggregation operations. It automatically invokes optimization for record selection and projection operations.
| Information Builders |