Help Center> Data Warehouse Service> Developer Guide> Query Performance Optimization> Optimization Cases> Case: Adjusting the Partial Clustering Key
Case: Adjusting the Partial Clustering Key
Symptom
Information on the EXPLAIN PERFORMANCE at a site is as follows: As shown in the red boxes, two performance bottlenecks are scan operations in a table.
Optimization Analysis
After further analysis, we found that the filter condition acct_id ='A012709548':: bpchar exists in the two tables.
Try to add the partial clustering key in the acct_id column of the two tables, and run the VACUUM FULL statement to make the local clustering take effect. The table performance is improved.
Parent topic: Optimization Cases
Last Article: Case: Adjusting the Distribution Key
Next Article: Case: Adjusting the Table Storage Mode in a Medium Table
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.