Answer C is correct. Using a clustered index usually improves performance. Making two separate views is likely to make the situation worse and will definitely make it more difficult to produce the desired results. Using the CLR will rarely improve performance for data-centric activities. A stored procedure is unlikely to perform any better than the view. For more information, see the following sources:
|