On this page
Help Center/ GaussDB(DWS)/ Performance Tuning/ Optimization Cases/ Case: Reconstructing Partition Tables

Case: Reconstructing Partition Tables

Updated on 2023-03-30 GMT+08:00

Symptom

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.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback