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
- 21068 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
Different phases of multiload?
What are the components used in smp and massively parallel processing (mpp) machines?
What is dimensional modeling?
How to eliminate product joins in a teradata sql query?
What do you mean by tpt in teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
how many modules are there in telecome domain?how to explain the architecture?
What is the purpose of upsert command?
What are the things to be considered while creating secondary index?
Is multi insert ansi standard?
What are the string manipulation operators and functions associated with teradata?
What is a three-tier data warehouse?
Can we collect statistics on table level?
What are the frequently used data types in teradata?
What are the different table types that are supported by teradata?
