1 Optimizing Table Schema Design
1.1 Case 1: Table Engine Selection
1.1.1 The query performance of these table models, from best to worst, is: Duplicate > MOW > MOR == Aggregate.
1.2 Case 2: Bucket Column Selection
1.2.1 Selecting appropriate bucket columns is vital for the reasonable distribution of raw data, effectively preventing performance issues caused by data skew.
1.3 Case 3: Key Column Optimization
1.3.1 Set columns frequently used in business queries as key columns to accelerate the query process.
1.4 Case 4: Field Type Optimization
1.4.1 While meeting the exp