Question & Answer
Question
Are temporary tables created in memory?
Answer
You can create a temporary table by running DDL similar to:
- MYDATABASE(ADMIN)=>create temporary table t1 (int1 integer);
The DDL above creates a table that is persisted on disk but this table will be implicitly dropped at the end of your session. For this reason, an explicit DROP TABLE statement is not required.
If you explicitly drop the table, the session cannot complete until the command is executed.
[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
NZ698058
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21570295