Temporary Tables

Session scoped scratch tables and how they compare to CTEs and views.

2 notes

Notes

A real table that exists only for your session. Learn CREATE TEMPORARY TABLE, its scope and lifetime, indexing it, and the dialect differences.

SQL

Four ways to name an intermediate result, and a decision rule for choosing between them based on scope, reuse and whether you need an index.