In this video, we cover what indexedviews 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 Nonenterprise Editions
6:56 The NOEXPAND table hint
8:18 Creating Nonclustered 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/sqlwind...
#sqlServer #IndexedView #MaterializedView