O'Reilly logo

Tera-Tom Genius Series - Kognitio Architecture and SQL by Leona Coffing, 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 12 – Temporary Tables

"You can make more friends in two months by becoming interested in other people, than you will in two years by trying to get other people interested in you."

- Dale Carnegie

There are Two 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

Temporary Table

Created by the User and materialized with an INSERT/SELECT

Space comes from the User’s space

Table and Data are deleted only after a User Logs off the session

The two types of Temporary tables are derived and temporary. You might be asking, "Where are the Global and Local table options for temporary tables"? Global and local temporary ...

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