Updated on 2022-07-29 GMT+08:00

Case: Reconstructing Partition Tables

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.