Query Tuning Parameters
Legacy Query Optimizer Operator Control Parameters
The following parameters control the types of plan operations the legacy query optimizer can use. Enable or disable plan operations to force the legacy optimizer to choose a different plan. This is useful for testing and comparing query performance using different plan types.
gp_enable_agg_distinct_pruning gp_enable_groupext_distinct_gather gp_enable_groupext_distinct_pruning gp_enable_predicate_propagation |
Legacy Query Optimizer Costing Parameters
Database Statistics Sampling Parameters
These parameters adjust the amount of data sampled by an ANALYZE operation. Adjusting these parameters affects statistics collection system-wide. You can configure statistics collection on particular tables and columns by using the ALTER TABLESET STATISTICS clause.