两个表查询，两个表都是上百万条记录，where条件都加了索引，但是查询非常慢，有什么优化办法吗？
select trade.trading_account,trade.trading_date,trade.windcode,trade.match_qty,entrust.business_action_id from RMS_TRADE_2020 as trade,RMS_ENTRUST_2020 as entrust
where trade.trading_date = entrust.trading_date
and trade.trading_account = entrust.trading_account
and trade.entrust_id = entrust.entrust_id
