强制索引force index(index_name)要加在select。。。from。。。后面
select * from salaries force index (idx_emp_no) where emp_no = 10005