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)
The following query is executed frequently against the SALES table: SELECT sales_person, region FROM sales WHERE region
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
The following query is executed frequently against the SALES table: SELECT sales_person, region FROM sales WHERE region
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!