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
- 19049 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
How is MLOAD Teradata Server restarted after execution?
What are the advantages of teradata?
Explain the term 'columns' related to relational database management system?
Explain parsing engine in teradata?
How many codd's rules are satisfied by teradata database?
Write a program to show the parser component used in teradata?
How to run a query in teradata?
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
What are the steps involved after the disk manager passes the request?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Why does varchar occupy 2 extra bytes?
How is the teradata different from oracle?
Explain amp in teradata?
What is upsert statement in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
