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
- 21341 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 the multi-insert?
What are the primary characteristics of the Teradata.
What tools would you use for that?
What are the available primary index types in teradata.
How can you track login parameters of users in teradata?
Explain teradata utilities?
What are the functions of a teradata dba?
What is bteq script in teradata?
Explain and compare pros and cons of start schemas?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Highlight a few of the important components of Teradata?
What are some commonly used bteq scripts?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What are the different softwares used with their functions in teradata?
