select *
from salaries FORCE INDEX(idx_emp_no)
where emp_no = 10005

MYSQL中强制索引查询使用：FORCE INDEX(indexname);

SQLite中强制索引查询使用：INDEXED BY indexname;