IBM
A2090-614 · Question #45
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…
The correct answer is C. CREATE INDEX bonus_salary_idx ON employee (bonus, salary) CLUSTER. See the full explanation below for the reasoning.
Question
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?
Options
- ACREATE INDEX salary_bonus_idx ON employee (salary, bonus)
- BCREATE INDEX bonus_salary_idx ON employee (bonus, salary)
- CCREATE INDEX bonus_salary_idx ON employee (bonus, salary) CLUSTER
- DCREATE INDEX salary_bonus_idx ON employee (salary, bonus) CLUSTER
How the community answered
(19 responses)- A16% (3)
- B5% (1)
- C74% (14)
- D5% (1)
Community Discussion
No community discussion yet for this question.