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