CREATE INDEX emp_dept_id_idx ON employee(dept_id); Which of the following statements are true with respect to the above index?
Answer options
A
May reduce the amount of disk I/O for INSERT statements. Increase the chance of full table scans. Override the unique index created when the FK relationship was define
B
May reduce the amount of disk I/O for SELECT statements.
Correct answer: May reduce the amount of disk I/O for SELECT statements.
Explanation
An index on dept_id speeds up SELECT queries filtering by that column.