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
- 16502 Views
- CTS, Lexicon, I also Faced
- E-Mail Answers
Answer Posted / tdguy
Sometimes, we may need aggregated data using some no of
columns from a very big table and these results are needed
in multiple sql requests In those cases, temporary tables
come in to picture and hold these temporary results for
further processing. When you need the table to be used
across sessions, GTT would be used so that definition would
be retained and can be reused by multiple users. When there
is a need only within the session, volatile table would be
used. These tables also help in speedy running of sqls.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is teradata?
what is sysdba and sysdbc ? which has high priority ?
any one answer me how they can analyzing the project using data ware housing?
How to select first n records in teradata?
How to load specific no.of records using bteq, or fastload,or multiload
If a Node is busy what are the steps you can take to avoid ?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What does sleep function does in fast load?
What happens in a conflict? How do you handle that?
What do you mean by teradata sql assistant?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Explain the new features of teradata?
What is smp and mpp platforms?
how can we analyze the locks ?
If RDBMS is halted what will you do ?
