States the term Volatile temporary tables

States the term Volatile temporary tables.

E

Expert

Verified

Volatile Temporary tables (VTT) -

1. Table Definition is stored within System cache
2. Data is stored within spool space.
3. Because of that data and table definition both are active only up to session ends.
4. No collects stats for VTT.

   Related Questions in Database Management System

©TutorsGlobe All rights reserved 2022-2023.