Which action should you take?

You are a database developer on an instance of SQL Server.
Your Prod database currently contains a view named OrderDetailsView that joins five tables.
Users will frequently perform queries using the view, and you want to improve the performance of these queries.
Which action should you take?
A. Create a filtered index on the view.
B. Partition the view.
C. Create a full-table nonclustered index on the view.
D. Create a unique clustered index on the view.

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.