Help Center > > Developer Guide> Query Performance Optimization> Optimization Cases> Case: Reconstructing Partition Tables

Case: Reconstructing Partition Tables

Updated at: Dec 30, 2020 GMT+08:00


In the following simple SQL statements, the performance bottlenecks exist in the scan operation of dwcjk.

Optimization Analysis

Obviously, there are date features in the cjrq field of table data in the service layer, and this meet the features of a partitioned table. Replan the table definition of the dwcjk table. Set the cjrq field as a partition key, and day as an interval unit. Define the partitioned table dwcjk_part. The modified result is as follows, and the performance is nearly doubled.

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