=>Derived temporary tables
a. Derived tables are local to an SQL query.
b. Not included in the DBC data dictionary database, the definition is kept in cache.
c. They are specified on a query level with an AS keyword in an sql statement
=>Volatile temporary tables
a. Local to a session ( deleted automatically when the session terminates)
b. Not included in the DBC data dictionary database and table definition is stored in cache. However, the volatile tables
=>Need to have unique names across the session.
a. Created by the CREATE VOLATILE TABLE sql statement
=>Global temporary tables
a. Global tables are local to a session and deleted automatically when the session terminates
b. A permanent table definition is stored in the DBC data dictionary database (DBC.Temptables)
c. defined with the CREATE GLOBAL TEMPORARY TABLE sql
a. Derived tables are local to an SQL query.
b. Not included in the DBC data dictionary database, the definition is kept in cache.
c. They are specified on a query level with an AS keyword in an sql statement
=>Volatile temporary tables
a. Local to a session ( deleted automatically when the session terminates)
b. Not included in the DBC data dictionary database and table definition is stored in cache. However, the volatile tables
=>Need to have unique names across the session.
a. Created by the CREATE VOLATILE TABLE sql statement
=>Global temporary tables
a. Global tables are local to a session and deleted automatically when the session terminates
b. A permanent table definition is stored in the DBC data dictionary database (DBC.Temptables)
c. defined with the CREATE GLOBAL TEMPORARY TABLE sql
No comments:
Post a Comment