Operator Configuration Parameters in Greenplum

1. gp_enable_sort_distinct

2. gp_enable_sort_limit

Aggregate Operator Configuration Parameters

1. gp_enable_agg_distinct

2. gp_enable_agg_distinct_pruning

3. gp_enable_multiphase_agg

4. gp_enable_preunique

5. gp_enable_groupext_distinct_gather

6. gp_enable_groupext_distinct_pruning

7. gp_workfile_compress_algorithm

Join Operator Configuration Parameters

1. join_collapse_limit

2. gp_adjust_selectivity_for_outerjoins

3. gp_hashjoin_tuples_per_bucket

4. gp_statistics_use_fkeys

5. gp_workfile_compress_algorithm