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
- 21554 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 a level of granularity of a fact table?
Highlight the need for Performance Tuning.
What is called partitioned primary index (ppi)?
What are the different design perspectives used in teradata?
Which is faster fastload or multiload?
how do you manage the production space. what are the proactive methods you can take ?
What is the syntax for case when statement?
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 is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
How is MLOAD Client System restarted after execution?
What are the different functions included in the server software?
Highlight a few of the advantages that ETL tools have over Teradata.
In Teradata, how do we Generate Sequence?
What exactly do you know about catching in teradata?
What is a node in teradata?
