Interested to Buy Any Domain ? << Click Here >> for more details...
In which scenarios we use Volatile tables and Global
temporary Tables in Real time? Please give me one real time
scenario???I know wat is its use??
- 3 Answers
- 16387 Views
- CTS, Lexicon, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
A volatile table is dropped at the end of the session(both
definition and data). It is stored in spool space and
statistics for the data cannot be collected. A global
temporary table's data alone is dropped at the end of the
session. It is stored in temp space and stats can be
collected. Any user can make use of the definition within
his temp space.
| Is This Answer Correct ? | 14 Yes | 6 No |
Post New Answer View All Answers
Where is teradata rdbms used?
What is the use of teradata system software?
What are the different design perspectives used in teradata?
What is the difference between teradata and basic rdbms?
What is the use of stored procedures in teradata?
What is called partitioned primary index (ppi)?
What is the opening step in basic teradata query script?
If RDBMS is halted what will you do ?
how can we analyze the locks ?
Explain Teradata performance tuning and optimization?
Explain the term 'primary key' related to relational database management system?
Explain vproc in teradata?
Explain teradata utilities?
Highlight a few of the important components of Teradata?
What are the functions involved in shared information architecture?
