Global Temporary tables

Question

Write down a short note on the Global Temporary tables (GTT).

Answer 1

Global Temporary tables (GTT):

a) Whenever they are created, its definition goes to Data Dictionary.

b) If materialized data goes in temp space.

c) That’s why, data is active up to the session ends and definition will remain there up to its not dropped by using Drop table statement.

d) When dropped from some other session then its must is Drop table all; you can collect stats on the GTT.