Try OpenEdge Now
skip to main content
SQL Development
Optimizing Query Performance : Understanding optimization : The statement parser : Views
 
Views
In OpenEdge SQL, views are low-cost because their definitions in terms of base tables are substituted into the query tree. The initial tree created by the parser treats views as though they were base tables. Before the query can be optimized, the view references must be resolved and applied to the tree. View resolution replaces each view reference with a subtree corresponding to the query expression found in the view definition.