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.
an indexed view
B.
a scalar function
C.
a table-valued function
D.
a table-valued type