---
title: "Discussion on \"Materialized view patterns, trade-offs, and when to use each on SQL Server/Azure SQL and .NET\" | Hashnode"
description: "Discussion on \"Materialized view patterns, trade-offs, and when to use each on SQL Server/Azure SQL and .NET\". What do we mean by “materialized view” on Azure SQL?\nSQL Server/Azure SQL doesn’t have Oracle-style materialized views; the closest native feature is an Indexed View (schema-bound view with a clustere"
url: "https://hashnode.com/posts/materialized-view-patterns-trade-offs-and-when-to-use-each-on-sql-server-azure-sql-and-net/6a3dccb2f544c53913ac31ef"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Materialized view patterns, trade-offs, and when to use each on SQL Server/Azure SQL and .NET](https://nova-globen.hashnode.dev/materialized-view-patterns-trade-offs-and-when-to-use-each-on-sql-server-azure-sql-and-net?utm_source=hashnode&utm_medium=feed)

What do we mean by “materialized view” on Azure SQL? SQL Server/Azure SQL doesn’t have Oracle-style materialized views; the closest native feature is an Indexed View (schema-bound view with a clustere

Jun 26 · 6 min read · nova-globen.hashnode.dev  
Read the article

-   [#materialized](https://hashnode.com/tag/materialized)
-   [#view](https://hashnode.com/tag/view)
-   [#pattern](https://hashnode.com/tag/pattern)
-   [#pagination](https://hashnode.com/tag/pagination)

## Written by

[Hossein Esmati](https://hashnode.com/@desmati)

@desmati · Stockholm, Sweden

  
[View profile](https://hashnode.com/@desmati)

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
