O'Reilly logo

Actian Matrix (Formely ParAccel) - Architecture and SQL by Ed Bernier, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required