O'Reilly logo

Tera-Tom's 1000 Page e-Book on Teradata Architecture and SQL, 2nd Edition by Tom Coffing, William 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 27 - Temporary Tables

“Those who would give up essential liberty to purchase a little temporary safety deserve neither liberty nor safety.”

-Benjamin Franklin

There are three types of Temporary Tables

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

Volatile
  Created by the User and materialized with an INSERT/SELECT
  Space comes from the User's Spool space
  Table and Data are deleted only after a User Logs off the session

Global Temporary Table
  Table definition is created by a User and the table definition is permanent
  Materialized with an INSERT/SELECT
  Space comes from the User's TEMP Space
  When User logs off the session the ...

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