设置一个储蓄业务的分区表设计及索引

分区表设计：

CREATE TABLE savings ( id INT PRIMARY KEY, account_number VARCHAR(20), deposit_amount DECIMAL(10, 2), transaction_date DATE ) PARTITION BY RANGE( YEAR(transaction_date) ) ( PARTITION p2019 VALUES LESS THAN (2020), PARTITION p2020 VALUES LESS THAN (2021), PARTITION p2021 VALUES LESS THAN (2022), PARTITION p2022 VALUES LESS THAN (2023) );

索引设计：

CREATE INDEX idx_savings_account_number ON savings(account_number); CREATE INDEX idx_savings_transaction_date ON savings(transaction_date)