You are the database administrator of a SQL Server 2005 computer named AIOTestKing A.
The following query is run frequently.
All tables referenced in the query are read-intensive with very few inserts and updates.
You cannot change existing objects in the database. You can add new objects to the database. You need to optimize the performance of the query. What should you do?
A.
Create an indexed view that contains all of the columns that are used in the query.
B.
Create a partitioned table that contains all of the columns that are used in the query.
C.
Create a view that contains all of the columns that are used in the query.
D.
Alter the current indexes by setting the FILLFACTOR option to 50.
Explanation:
By creating a indexed view of the tables needed you don’t need to access the tables themselves every time you execute the query and therefore you get a better performance on the query.