Following are the types of views in SQL SERVER 2005

1.Standard Views are the views which combines data from one or more tables.They do not have index on them

2.Indexed Views are the views with index on them.
Database stores these type of views.You can create clustered index and
non clustered on view.Only thing important here is first you need to
create a clustered index to create a non clustered index.These types of
views are called materialized views.

3.Partitioned view are views that joins horizontally
partitioned data from a set of member tables. A view that joins member
tables on the same instance of SQL Server is a local partitioned view.

Pawan Kumar
Pawankkmr@hotmail.com

Advertisements