Subqueries are notoriously expensive to evaluate. This section describes some of the transformations that makes internally to reduce the cost of evaluating them. Subqueriesprocessing and transformations of