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.
Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms191432.aspx
D
C fo shoe! “For example, some developers find it useful to create indexed views that precompute and store the answers to queries for reports run at the end of each month by senior executives.” -> https://technet.microsoft.com/en-us/library/dd171921%28v=sql.100%29.aspx