### 平仓明细表 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`);