View transformations

When Derby evaluates a statement that references a view, it transforms the reference to a view into a derived table. It might make additional transformations to improve performance.

• View flattening
  When evaluating a statement that references a view, Derby internally transforms a view into a derived table. This derived table might also be a candidate for flattening into the outer query block.
• Predicates pushed into views or derived tables
  An SQL statement that references a view can also include a predicate.