A view is a virtual table that consists of data columns from one or more tables. In simple terms, it is a stored query that works as an object of a database, such as a table. A view can be treated exactly like a table; it can be used in any stored procedure,
Join, UDF, and so on.
A view provides the following two main benefits:
When you query the view, the query optimizer complies a single execution plan for the query. The query optimizer searches through a set of possible execution plans for a ...