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
Answer Posted / humayun
yes we camn collect statistics on globaltemporary table
wher as we cant on derived and volatile because these table
will be created under spool mempory.and global tempoary
tables will be created to get the intemediate results this
table will be created and dropped as part of the query.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the use of virtual processor connectivity in teradata?
During the Display time, how is the sequence generated by Teradata?
Highlight all the modes that are present under Confidence Level.
What's the difference between timestamp (0) and timestamp (6)?
When tpump is used instead of multiload?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Explain fallback in teradata?
What is the use of teradata system software?
Which is faster fastload or multiload?
What is spool space?
What are the various indexes in teradata? How to use them?
What are the main components of teradata system?
Describe primary index in teradata. And what are the available primary index types?
Differentiate primary key and partition key?
why use references rather than pointers in the public api, particularly for arguments which are modified?