The following query is executed frequently against the SALES table: SELECT sales_person, region FROM sales WHERE region
Posted: Fri Aug 26, 2022 9:58 am
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)
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)