What should you do?

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. Youneed to improve the performance of the reports.
What should you do?

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. Youneed 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:
Verified answer as correct.
Reference: http://msdn.microsoft.com/en-us/library/ms191432.aspx



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Google

Google

That may be the finish of this article. Here youll find some websites that we assume youll appreciate, just click the links.