Indexed Views (Materialized Views) in SQL Server and Performance Considerations

In this video, we cover what indexed-views are in SQL Server, how we can create them, and how they can improve query performance.

0:00 - Intro
0:30 - Querying a Normal Database View
1:08 - Querying an Indexed View
2:57 - Demonstration
3:08 - The WITH SCHEMABINDING attribute
3:26 - Official Documentation for Indexed Views
5:28 - Enabling Statistics IO to monitor the performance
5:47 - The Execution Plan
6:22 - Creating a Clustered Index on a View
6:37 - Indexed Views on Non-enterprise Editions
6:56 - The NOEXPAND table hint
8:18 - Creating Non-clustered Indexes on a View
9:05 - Indexed Views and the GROUP BY clause
9:28 - The COUNT_BIG function
10:26 - Query Performance Comparison

The complete course:
Database Views play a fundamental part in Database Development, whether it's for reporting, productivity, or security, you'll hardly come across a database that doesn't contain views. In the course, I will teach you the basic and advanced implementations of Database Views.

Are you ready to join in?

Link to the course (87% Discount):
https://www.udemy.com/course/designing-and-implementing-views-in-sql-server/?couponCode=88DE0FA350B81E1DC160
#sqlServer #IndexedView #MaterializedView

Видео Indexed Views (Materialized Views) in SQL Server and Performance Considerations канала KeepLearningIT