Go back to C2090-614 - DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam

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?
CREATE INDEX sales_idx ON sales (region)
CREATE INDEX sales_idx ON sales (sales_person)
CREATE INDEX sales_idx ON sales (region, sales_person)
CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)

Want to practice for C2090-614 - DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam ? Click here.