The following query is executed frequently against the EMPLOYEE table: SELECT empid, salary,
bonus FROM employee ORDER BY bonus, salary; Which statement will create an index for
optimal query performance?

A.
CREATE INDEX salary_bonus_idx ON employee (salary, bonus)

B.
CREATE INDEX bonus_salary_idx ON employee (bonus, salary)

C.
CREATE INDEX bonus_salary_idx ON employee (bonus, salary) CLUSTER

D.
CREATE INDEX salary_bonus_idx ON employee (salary, bonus) CLUSTER

Explanation: