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
- 16576 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
What is inner join and outer join?
Explain teradata architecture in detail with a diagram.
How do you see a ddl for an existing table?
Did you write stored procedures in teradata?
Is multi insert ansi standard?
If RDBMS is halted what will you do ?
Explain the meaning of Amp?
What can be achieved by using the teradata rdbms?
What is stored procedure in teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
What is the syntax for case when statement?
What are the enhanced features in teradata v2r5 and v2r6?
What is teradata?
In BTEQ, how are the session-mode parameters being set?
What is logical data model?
