GPORCA Configuration Parameters

    • optimizer_analyze_root_partition

    • optimizer_array_expansion_threshold

    • optimizer_cte_inlining_bound

    • optimizer_enable_associativity

    • optimizer_force_multistage_agg

    • optimizer_force_three_stage_scalar_dqa

    • optimizer_join_arity_for_associativity_commutativity

    • optimizer_join_order

    • optimizer_metadata_caching

    • optimizer_parallel_union

    • optimizer_print_missing_stats

    • optimizer_print_optimization_stats