You develop a Microsoft SQL Server 2012 database. You create a view that performs the following tasks:

Joins 8 tables that contain up to 500,000 records each.

Performs aggregations on 5 fields.

The view is frequently used in

several reports.

You need to improve the performance of the reports.

What should you do?

A. Convert the view into a table-valued function.

B. Convert the view into a Common Table Expression (CTE).

C. Convert the view into an indexed view.

D. Convert the

view into a stored procedure and retrieve the result from the stored procedure into a temporary table.

Reference: http://msdn.microsoft.com/en-us/library/ms191432.aspx