Wednesday, February 9, 2011

what is Volatile table?

If you need a temporary table for a single use only, you can define a volatile table. The definition of a volatile table resides in memory but does not survive across a system restart.

Using volatile tables improves performance even more than using global temporary tables
because the system does not store the definitions of volatile tables in the Data Dictionary.
Privilege checking is not necessary because only the creator can access the volatile table.

No comments:

Post a Comment