Optimization Cases

Case: Selecting an Appropriate Distribution Column
Case: Creating an Appropriate Index
Case: Adding NOT NULL for JOIN Columns
Case: Pushing Down Sort Operations to DNs
Case: Configuring cost_param for Better Query Performance
Case: Adjusting the Distribution Key
Case: Adjusting the Partial Clustering Key
Case: Adjusting the Table Storage Mode in a Medium Table
Case: Adjusting the Local Clustering Column
Case: Reconstructing Partition Tables
Case: Adjusting the GUC Parameter best_agg_plan
Case: Rewriting SQL and Deleting Subqueries (Case 1)
Case: Rewriting SQL and Deleting Subqueries (Case 2)
Case: Rewriting SQL Statements and Eliminating Prune Interference
Case: Rewriting SQL Statements and Deleting in-clause
Case: Setting Partial Cluster Keys

Parent topic: Query Performance Optimization