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

image

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

The Three Components of a Derived Table

image

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.