Cannot create %1!s! on view "%2!s!" because it uses aggregate "%3!s!". Consider eliminating the aggregate, not indexing the ...

Cannot create %1!s! on view "%2!s!" because it uses aggregate "%3!s!". Consider eliminating the aggregate, not indexing the view, or using alternate aggregates. For example, for AVG substitute SUM and COUNT_BIG, or for COUNT, substitute COUNT_BIG.