View implementation

Views, derived tables (nested table expressions or NTEs), and common table expressions (CTEs) are implemented by the query optimizer using one of two methods.

These methods are:

• The optimizer combines the query select statement with the select statement of the view.
• The optimizer places the results of the view in a temporary table and then replaces the view reference in the query with the temporary table.