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

Updated on 2025-09-19 GMT+08:00

View PDF

SQL Tuning Examples

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 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.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

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