O'Reilly logo
Safari Logo
Start Free Trial
Sign In
Pricing
Enterprise
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
Teradata SQL 7 – Volatile and Global Temporary Tables
by Tom Coffing
Publisher: Coffing Studios
Release Date: September 2014
ISBN: 10023COFFINGVID23
View table of contents
Start watching
Video Description
This chapter will explain both Volatile and Global Temporary Tables.
Table of Contents
Teradata SQL: Creating and Inserting into a Volatile Table
00:02:17
Teradata SQL: Using the ON COMMIT DELETE ROWS Statement in a Volatile Table
00:03:05
Teradata SQL: Joining Volatile Tables with the Primary Index!
00:03:09
Teradata SQL: Collecting Statistics on a Volatile Table!
00:02:07
Teradata SQL: Four Examples of Volatile Tables!
00:02:48
Teradata SQL: Four ADVANCED Examples of Volatile Tables
00:03:01
Teradata SQL: Partitioned Primary Index Volatile Tables and Removing Duplication
00:03:20
Teradata SQL: The Basics of Global Temporary Tables
00:04:38