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
- 19618 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 is stored procedure in teradata?
How is the teradata different from oracle?
Where is teradata rdbms used?
What are the commands to make a new table, change a table and remove a table in teradata?
What is database exceptions in teradata?
What is real time and near real time data warehousing?
What are aggregate tables? How do you design them using teradata?
How do you set the session mode parameters in bteq?
Syntax for case when statement?
What is the function of parser component in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Explain teradata utilities. What is multiload, fast load, tpump?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
How to find duplicates in a table?
