题解 | #针对上面的salaries表emp_no字段创建索引idx_emp_no#
针对上面的salaries表emp_no字段创建索引idx_emp_no
http://www.nowcoder.com/practice/f9fa9dc1a1fc4130b08e26c22c7a1e5f
使用强制索引查询的语法为:
DELETE|SELECT|UPDATE
COLUMNS
FROM
TABLE_NAME
INDEXED BY index_name
WHERE
index_column = condition
则此题的答案为
SELECT
*
FROM
salaries
INDEXED BY idx_emp_no
WHERE emp_no = 10005