Volatile Temporary tables

Write down a short note on the Volatile Temporary tables (VTT).

E

Expert

Verified

Volatile Temporary tables (VTT):

a) Table Definition is stored in the System cache.

b) Data is stored in the spool space.

c) That is why, data and table definition both are active merely to session ends.

d) No collect stats for VTT.

   Related Questions in Database Management System