If AVG(expression) is specified in queries referencing the indexed view, the optimizer can frequently calculate the needed result if the view select list contains SUM(expression) and COUNT_BIG(expression).

• 如果在引用索引视图的查询中指定了AVG(expression),则当视图SELECT列表中包含SUM(expression)和COUNT_BIG(expression)时,优化器可经常计算所需结果。