题解 | 针对上面的salaries表emp_no字段创建索引idx_emp_no
针对上面的salaries表emp_no字段创建索引idx_emp_no
https://www.nowcoder.com/practice/f9fa9dc1a1fc4130b08e26c22c7a1e5f
select * from salaries FORCE INDEX(idx_emp_no) where emp_no = 10005
MYSQL中强制索引查询使用:FORCE INDEX(indexname);
SQLite中强制索引查询使用:INDEXED BY indexname;