Niko Neugebauer • 1/1/2020

Azure SQL DW Materialized Views (part 1)

This article introduces Materialized Views in Azure SQL DW (Azure Synapse Analytics), a recently GA feature. It explains how they differ from traditional SQL Server indexed views, acting as a physical cache for aggregation queries to optimize performance in data warehouse environments by reducing repetitive CPU-intensive operations.

0 comments

#Database Optimization #Materialized Views #Data Warehousing