Types of Views in Sql Server

There are 3 type of views in Sql Server:

1 - Standard View
2 - Indexed View
3 - Partitioned View

1 - Standard View

Standard View is a genral view that we know all about.

2 - Indexed View

An indexed view is a view that has been materialized. This means it has been computed & stored. You index a view by creating a unique clustered index on it. Indexed view improve the performance of the some type of queries. Indexed view work best for queries that aggregate many rows. They are not well suited for underlying data sets thar are frequently updated.

3 - Partitioned View

A view is a partitioned view that join horizontally partitioned data from a set of member tables across one or more servers.

- A view that join member tables on the same instance of Sql Server is called local partitioned view.

- A view that join data from tables across server is called distributed pertitioned view.

Regards
Manish