联合索引

### 平仓明细表 t_deal_close_detail
ALTER TABLE `t_deal_close_detail` DROP INDEX idx_strat_inst_id,
DROP INDEX idx_sub_account_id, DROP INDEX idx_account_id, DROP INDEX idx_portfolio_id;

ALTER TABLE `t_deal_close_detail` ADD INDEX idx_str_td (`strat_inst_id`,`trade_date`),
ADD INDEX idx_sub_td (`sub_account_id`,`trade_date`),
ADD INDEX idx_acc_td (`account_id`,`trade_date`),
ADD INDEX idx_por_td (`portfolio_id`,`trade_date`);

### 成交明细表 t_deal_detail
ALTER TABLE `t_deal_detail` DROP INDEX idx_strat_inst_id,drop index idx_sub_account_id,
drop index idx_account_id,drop index idx_portfolio_id;

ALTER TABLE `t_deal_detail` ADD INDEX idx_str_td (`strat_inst_id`,`trade_date`),
ADD INDEX idx_sub_td (`sub_account_id`,`trade_date`),
ADD INDEX idx_acc_td (`account_id`,`trade_date`),
ADD INDEX idx_por_td (`portfolio_id`,`trade_date`);
posted @ 2022-08-31 17:32  91程序猿  阅读(46)  评论(0编辑  收藏  举报