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 / yuvaevergreen
No for volatile and derived tables and yes for golobal
tables. Global tables are temp tables like volatile tables
but unlike volatile tables, their definitions are retained
in dd. It is used whenever there is a need for a temporary
table with same table definition for all users.
Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What is TPD?
What is meant by a Highest Cost Plan?
What is difference between user and database in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Difference between stored procedure and macro?
How to load specific no.of records using bteq, or fastload,or multiload
What is the use of virtual processor connectivity in teradata?
What is the use of teradata system software?
What is a node in teradata? Explain
What are normalization, first normal form, second normal form and third normal form?
Describe primary index in teradata?
What do you mean by fastexport in teradata?
Explain the term 'tables' related to relational database management system?
What are tpump utility limitations?
What is a sparse index?