Help Center > > Developer Guide> Query Performance Optimization> Optimization Cases> Case: Adjusting the Partial Clustering Key

Case: Adjusting the Partial Clustering Key

Updated at: Jul 15, 2020 GMT+08:00

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel