SELECT *
FROM table_name
FORCE INDEX (`index_name`)
WHERE
示例
explain select * from pl_repayment_plan_user u #FORCE INDEX (`INDEX_REALPAYMENT`) where u.real_repay_time > '2018-10-31 16:57:04'
强制索引后
explain select * from pl_repayment_plan_user u FORCE INDEX (`INDEX_REALPAYMENT`) where u.real_repay_time > '2018-10-31 16:57:04'
