You have a database that has 20 large tables. All the tables have qualified indexes. As the tables grow, you discover that queries that contain JOIN statements execute more slowly.
You need to recommend a solution to decrease the query response time and the I/O. The solution must minimize hardware costs. What should you recommend?
A.
Implement query hints.
B.
Create a filegroup strategy.
C.
Implement an index strategy.
D.
Create a partitioning strategy.