Using materialized views to improve performance
In this recipe, you will learn how materialized views can help in solving complex queries that are required for analytical purposes and how you can gain performance. You will learn how to create the materialized view, and when and why to use it in the SQL dedicated pool.
Materialized views are the best option in a large data warehouse, as the data is stored in a pre-processed format, unlike standard views. When you execute a query with a materialized view, it internally keeps processed data within the dedicated SQL pool, just like a physical SQL table.
Getting ready
Before you begin, make sure you have the following:
- Make sure you have the dedicated SQL pool available in the Synapse workspace.
- You need to ensure that the table in which you are creating a materialized view has a qualifying column that can participate in the columnstore index. You can refer to this document for a list of datatypes that can participate...
