You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com include maintaining a SQL Server 2005 database named Certkiller -DB06.
Analysts in the Sales department of Domain.com usually make use of a view named v_ClientSales to join the Clients and the Sales tables in the Certkiller -DB06. The analysts make use of this view to combine the total sales by clients per month. You want to increase the performance of the view.
What should you do?
A.
You should create two separate views that do not contain any joints.
Then name the one view named v_Clients for the Clients table and the other v_Sales for the Sales table.
B.
You should update the view to use an outer join between the Clients and Sales tables.
C.
You should create a stored procedure for the business analysts that make use of the v_ClientSales view.
D.
You should create a clustered index on the v_ClientSales view.
Explanation:
As a view is nothing more than a virtual table containing data from one or more tables you have the option to create a clustered index on the view in order to obtain an indexed view and obtain performance benefits.