Subqueries are notoriously expensive to evaluate. This section describes some of the transformations that Derby makes internally to reduce the cost of evaluating them.
Scripting on this page tracks web page traffic, but does not change the content in any way.