2.21 Inner derived tables

View tables and the query names of the WITH clause are called named derived tables.

When a named derived table is specified in a query specification, an internal work table may be created for the named derived table. A named derived table for which a work table is created is called an inner derived table.

Organization of this section
2.21.1 Conditions for an inner derived table