How should you configure the view to ensure optimal performance?
A. You should create the view as an indexed view.
B. You should create a clustered index on the view.
C. You should make use of a stored procedure to return that data.
D. You should make use of a table-valued function.
Answer:A
How should you configure the view to ensure optimal performance?
A. You should create the view as an indexed view. B. You should create a clustered index on the view. C. You should make use of a stored procedure to return that data. D. You should make use of a table-valued function.