Question

CREATE INDEX customer_dept_id_idx ON cutomer_info(cust_id);

Which of the following statements are true with respect to the above index?



Select one:
Increase the chance of full table scans.
May reduce the amount of disk I/O for SELECT statements.
May reduce the amount of disk I/O for INSERT statements.
Store an index in the CUSTOMER_INFO table.
Override the unique index created when the FK relationship was defined.

Answer 1

Explanation:

May reduce the amount of disk I/O for SELECT statements.