Try OpenEdge Now
skip to main content
SQL Development
Optimizing Query Performance : Understanding optimization : The statement parser : Quantified predicates and other subqueries
 
Quantified predicates and other subqueries
In OpenEdge SQL, subqueries are low-cost because they are folded into the query tree as joins. The parser translates subqueries, such as predicates preceded by ANY and ALL, to an equivalent form that does not contain these keywords. Usually, the new form is a join between the data in the subquery and the data in the remainder of the SQL statement.