![sql server materialized view sql server materialized view](https://www.enterprisedb.com/images/ombres/ombre-cyan-5-to-indigo-6.jpg)
This restriction doesn't apply to INSERTs.
#Sql server materialized view update#
The materialized view will be disabled when an UPDATE or DELETE occurs in the referenced base tables. i_rec_end_date) as min_i_rec_end_date, i. i_rec_start_date) as max_i_rec_start_date, MIN( i. WITH (distribution = hash(i_category_id), FOR_APPEND)ĪS SELECT MAX( i. When MIN/MAX aggregates are used in the SELECT list of materialized view definition, following requirements apply: Supported aggregations include MAX, MIN, AVG, COUNT, COUNT_BIG, SUM, VAR, STDEV. Up to 32 columns can be used in the GROUP BY clause.Īggregate functions are required in the SELECT list of the materialized view definition.