Help Center/Data Warehouse Service/Developer Guide/Developer Guide (9.1.1.x)/DWS Performance Tuning/SQL Tuning Examples

Updated on 2026-01-04 GMT+08:00

SQL Tuning Examples

Case: Selecting an Appropriate Distribution Column

Case: Creating an Appropriate Index

Case: Adding NOT NULL for JOIN Columns

Cases: Modifying Statements That Cannot Be Pushed Down

Case: Configuring cost_param for Better Query Performance

Case: Adjusting the Partial Clustering Key

Case: Adjusting the Table Storage Mode in a Medium Table

Case: Reconstructing Partition Tables

Case: Adjusting the GUC Parameter best_agg_plan

Case: Rewriting SQL Statements and Eliminating Prune Interference

Case: Rewriting SQL Statements and Deleting in-clause

Case: Setting Partial Cluster Keys

Case: Converting from NOT IN to NOT EXISTS

Parent Topic: DWS Performance Tuning

Previous topic: Query Band Load Identification

Next topic: Case: Selecting an Appropriate Distribution Column

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

For any further questions, feel free to contact us through the chatbot.