mysql强制使用索引

force index(key):强制走索引key

 

select * from salaries force index(idx_emp_no)
where emp_no = 10005