O'Reilly logo

Microsoft Azure SQL Data Warehouse - Architecture and SQL by Todd Wilson, 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

“Graffiti’s always been a temporary art form. You make your mark and then they scrub it off.”

- Banksy

Temporary Tables

Derived Tables

•Is a SELECT Statement with a SELECT Statement

•Is purely logical as opposed to physical

•Exists only within a query

•Has its execution optimized at run time

Temporary Table

Is always created as #tablename

Space comes from tempdb

Can only be used by the connection that created the table

Can be created by the User, then populated with an INSERT/SELECT

Table and Data are deleted after the connection that created the table is closed

Derived tables exist for the life of a single query, but the database tempdb is used by the Azure SQL Data Warehouse system for local temporary tables. ...

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