Simplify commands for the user.
-
For example, views allow users to select information from multiple tables without requiring the users to actually know how to perform a correlated subquery
|
Present the data in a different perspective from that of the base table.
-
For example, views provide a means to rename columns without affecting the tables on which the view is based
|
Store complex queries.
-
For example, a query might perform extensive calculations with table information.
-
By saving this query as a view, the calculations are performed only when the view is queried
|
