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
Difference between star and snowflake schemas?
How to view every column and the columns contained in indexes in teradata?
Describe primary index in teradata?
What do you mean by fastexport in teradata?
What are the main components of teradata system?
What is the command in bteq to check for session settings ?
Highlight the limitations of TPUMP Utility.
How do you see a ddl for an existing table?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is upsert statement in teradata?
In general, how do you optimze any sql in teradata?
How do you do backup and recovery in teradata?
What are the various reporting tools in the market?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Explain the new features of teradata?