“I cannot imagine any condition which would cause this ship to founder. Modern shipbuilding has gone beyond that.”
- E. I. Smith, Captain of the Titanic
Exists only within a queryMaterialized by a SELECT Statement inside a querySpace comes from the User’s Spool spaceDeleted when the query ends
Created by the User and materialized with an INSERT/SELECTSpace comes from the User’s spaceTable 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 tables do not ...