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):
#sqlServer #IndexedView #MaterializedView

[CitAllHearItAll]

You rule.
I have been using stored procedure to truncate and load SQL queries instead of using views to achieve this result.

Materialized views sounds like a great way to keep the ETL process cleaner by removing the need to add stored proc calls.

[AlejandroBelloRD]

Most excellent primer on materialized views on Microsoft SQL Server. Thank you so much!

[volodymyrliashenko]

Very helpful! Please a create a second part for partitions!

[datauntelligence]

good tips. thanks for the information

[adrianalvarado]

I failed that question on my last interview u_u

[rockedwardradical]

can I create indexes between linked servers?

[abdullah_ahmed_sherdy]

i need a backup of this database can you give me this