UPDATE t_comment com SET com.create_time=(SELECT finish_time FROM t_order o where o.order_id=com.order_id);
t_comment 表中相关索引 :
PRIMARY KEY (`id`),KEY `ind_t_comment_orderid` (`order_id`) USING BTREE
t_order 表中相关索引:
PRIMARY KEY (`order_id`),KEY `t_order_finish_time` (`finish_time`) USING BTREE
EXPLAIN UPDATE t_comment com SET com.create_time=(SELECT finish_time FROM t_order o where o.order_id=com.order_id);
实际情况下t_comment没有使用到索引
执行执行上万条数据的时候就相当慢了
求帮助