What Is Indexed View In SQL By Sagar Jaybhay

Sql Server By Sagar Jaybhay

In this article we will understand What Is Indexed View In SQL Server By Sagar Jaybhay. Indexed View A normal view or non-indexed view is a saved SQL query or a virtual table. When you try to get data from the table the data is coming from an underlying table. So it means the view is a virtual table and doesn’t store any data. But when you create an index on view it gets materialized which means you can store data in view so in the SQL server we called…

Read More