PrepAway - Latest Free Exam Questions & Answers

To improve performance:

There is a query that uses SUM, AVG and MAX. To improve performance:

PrepAway - Latest Free Exam Questions & Answers

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


Leave a Reply