Overview of GPORCA

GPORCA also enhances HAWQ query performance tuning in the following areas:

The following flow chart shows how GPORCA fits into the query planning architecture:

You can inspect the log to determine whether GPORCA or the legacy query optimizer produced the plan. The log message, “Optimizer produced plan” indicates that GPORCA generated the plan for your query. If the legacy query optimizer generated the plan, the log message reads “Planner produced plan”. See Determining The Query Optimizer In Use.