O'Reilly logo

Teradata Architecture for IT and Developers by Tom Coffing, John Nolan

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 15 - Temporary Tables

“To escape criticism – do nothing, say nothing, be nothing.”

– Elbert Hubbard

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 Table

•   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