You have a table that has 10 million rows. The table has a view that returns all of the rows.
You discover performance degradation when you run an unfiltered view. You need to
recommend a solution to replace the view. The solution must require that the returned data
is filtered by a parameter. What should you use?
A.
a table-valued type
B.
an indexed view
C.
a scalar function
D.
a table-valued function