You have a server that runs SQL Server 2008 Enterprise. You have a query that contains
SUM, AVG, and MAX functions. You discover that the query takes a long time to execute.
You need to reduce the amount of time required to execute the query. What should you do?
A.
Add computed columns that have persisted values to the table that contains the
aggregate values on a per row basis.
B.
Create an indexed view in which each aggregate function is computed.
C.
Add computed columns to the table that contains the aggregate values on a per row
basis.
D.
Create a view in which each aggregate function is computed.