Chapter 14 – Temporary Tables

“I cannot imagine any condition which would cause this ship to founder. Modern shipbuilding has gone beyond that.”

- E. I. Smith, Captain of the Titanic

CREATING A Derived Table

•Exists only within a query

•Materialized by a SELECT Statement inside a query

•Space comes from the User’s Spool space

•Deleted when the query ends


The SELECT Statement that creates and populates the Derived table is always inside Parentheses.

The Three Components of a Derived Table


A derived table will always have a SELECT query to ...

Get Actian Matrix (Formely ParAccel) - Architecture and SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.