Interested to Buy Any Domain ? << Click Here >> for more details...
Can we take collect stats on Dervied Tables and Volitable
tables,
What is Golabal Temporary table what is the use of this
Golabal Temporary table ,When we create any kind table in
Teradata it will show in Golabal Temporary table
- 6 Answers
- 21296 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / tdguy
In TD14.0, stats can be collected for volatile tables also.
GTTs are stored in temporary space and definition alone is
retained across sessions. Temporary tables are used, when
there is a need to store some aggregate results of rows for
further sql processing. It also increases the need to join
big tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the steps to create a data model?
List out all forms of LOCKS that are available in Teradata.
What are aggregate tables? How do you design them using teradata?
What is a node in teradata? Explain
What are the different functions performed in development phase?
Difference between multiload and tpump?
Did you write stored procedures in teradata?
what is sysdba and sysdbc ? which has high priority ?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What do high confidence, low confidence and no confidence mean in explain plan?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
When tpump is used instead of multiload?
Explain the term 'primary key' related to relational database management system?
Explain how spool space is used.
