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