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
- 19078 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
In Teradata, what is the significance of UPSERT command?
What is teradata?
how can we analyze the locks ?
What is meant by a node?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is meant by a Virtual Disk?
What do you mean by teradata intellicloud?
What is oltp?
What are the uses of client software involved in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What are the main components of teradata system?
Explain teradata architecture?
What is the difference between fastload and multiload?
Why do you get spool space errors? How do trouble-shoot them?
