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 are the updated features of teradata?
What is the use of stored procedures in teradata?
Explain the most common data types used in teradata?
What is node? How many nodes and amps used in your previous project?
What's the difference between timestamp (0) and timestamp (6)?
Syntax for case when statement?
What are the frequently used data types in teradata?
How to view every column and the columns contained in indexes in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is the purpose of upsert command?
What are the functions performed by bynet?
Explain teradata architecture?
What are the joins in teradata and how many types of joins are there in teradata?
What are teradata utilities?
What are the various indexes in teradata? How to use them?