System Administrator Guide > System Administrator Guide > Understanding Ingres Components > DBMS Server Facilities > Optimizer Facility
Was this helpful?
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). For X100 queries, the QEP includes the X100 algebra used by the X100 engine. OPF uses a memory pool for its operations.
Last modified date: 01/30/2023