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
- 19616 Views
- IBM, I also Faced
- E-Mail Answers
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 collect statistics?
What are the available primary index types?
Explain Teradata performance tuning and optimization?
Explain the parallel data extension in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Explain teradata architecture?
What are different table types used in teradata?
In the Primary Index, what is the score of AMPs that are actively involved?
What is multi insert?
What is TPD?
What are types of partition primary index (ppi) in teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Explain how spool space is used.
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Explain the teradata primary index mechanics in detail with a diagram.
