You work as the database developer for Domain.com. The Domain.com network contains a database server named Certkiller -DB01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company. Domain.com Sales Representatives should be allowed to check the current commissions due to them.
You need to optimize the indexing strategies for the CK_Sales database. You need to design the indexes for the Orders table. The following query is frequently executed, though it is not the most commonly executed query.
SELECT Salesrepresentative, SUM(Commission)
FROM Orders
WHERE Date BETWEEN @startDate AND @endDate
GROUP BY Salesrepresentative
ORDER BY Salesrepresentative
You need to use the appropriate statement to create the best index to accommodate this query.
What statement should you use?