There is a query that uses SUM, AVG and MAX. To improve performance:
A.
create a VIEW that implemented the aggregates as computed columns
B.
create an indexed VIEW that implements the aggregates as computed columns
C.
create computed columns for aggregates on a per row basis
D.
create persisted computed columns for aggregates on a per row basis