Question: tsql can you index a view?
Answer: A query can use an indexed view in its execution plan even if it does not satisfy these GROUP BY restrictions. If the view definition contains a GROUP BY clause, the key of the unique clustered index can reference only the columns specified in the GROUP BY clause.