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
- 16711 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
How do you set the session mode parameters in bteq?
What is smp and mpp platforms?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Explain BYNET.
What is partitioned primary index (ppi)?
How can bottlenecks be identified?
Can we collect statistics on table level?
Explain teradata utilities?
What is the syntax for case when statement?
Explain and compare pros and cons of snow flake schemas?
What are the advantages of teradata?
Why teradata is used?
What do you mean by ttu in teradata?
Highlight the advantages of PPI(Partition Primary Index).
Mention a few of the ETL tools that come under Teradata.
