2. Understanding Ingres Components : DBMS Server Facilities : Optimizer Facility
 
Share this page                  
Optimizer Facility
The Optimizer Facility (OPF) selects the optimal plan for implementing queries. It also converts the query tree that comes out of the parser into the query execution plan (QEP). OPF uses a memory pool for its operations.