IBM
A2090-614 · Question #83
The following query is executed frequently against the SALES table: SELECT sales_person, region FROM sales WHERE region = 'Quebec' Which statement will create an index for optimal query performance?
The correct answer is C. CREATE INDEX sales_idx ON sales (region, sales_person). See the full explanation below for the reasoning.
Question
The following query is executed frequently against the SALES table: SELECT sales_person, region FROM sales WHERE region = 'Quebec' Which statement will create an index for optimal query performance?
Options
- ACREATE INDEX sales_idx ON sales (region)
- BCREATE INDEX sales_idx ON sales (sales_person)
- CCREATE INDEX sales_idx ON sales (region, sales_person)
- DCREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)
How the community answered
(21 responses)- A5% (1)
- B10% (2)
- C86% (18)
Community Discussion
No community discussion yet for this question.