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?

A.
CREATE INDEX sales_idx ON sales (region)

B.
CREATE INDEX sales_idx ON sales (sales_person)

C.
CREATE INDEX sales_idx ON sales (region, sales_person)

D.
CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)

Explanation: