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