SELECT
*
FROM
salaries INDEXED BY idx_emp_no
WHERE
emp_no = 10005
**注意:**MySQL中,使用 FORCE INDEX 语句进行强制索引查询
SELECT
*
FROM
salaries FORCE INDEX idx_emp_no
WHERE
emp_no = 10005
SELECT
*
FROM
salaries INDEXED BY idx_emp_no
WHERE
emp_no = 10005
**注意:**MySQL中,使用 FORCE INDEX 语句进行强制索引查询
SELECT
*
FROM
salaries FORCE INDEX idx_emp_no
WHERE
emp_no = 10005