You are employed as a database administrator at Hi-tech Company. The Hi-tech Company network consists of a single Active Directory domain named Hi-tech Company. Your duties at Hi-tech Company include maintaining a SQL Server 2005 database named DataBase01.
Analysts in the Sales department of Hi-tech Company usually make use of a view named v_ClientSales to join the Clients and the Sales tables in the DataBase01. 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.