GPORCA Configuration Parameters

• optimizer

• optimizer_analyze_root_partition

• optimizer_array_expansion_threshold

• optimizer_cte_inlining_bound

• optimizer_enable_associativity

• optimizer_control

• optimizer_enable_master_only_queries

• optimizer_force_multistage_agg

• optimizer_force_three_stage_scalar_dqa

• optimizer_join_arity_for_associativity_commutativity

• optimizer_join_order

• optimizer_join_order_threshold

• optimizer_mdcache_size

• optimizer_metadata_caching

• optimizer_parallel_union

• optimizer_print_missing_stats

• optimizer_print_optimization_stats

• optimizer_sort_factor
  
  

Parent topic: Query Tuning Parameters