can we join volatile table with general table an global
temporary table with general table
?
Answer Posted / tdguy
yes. its possible. And in TD 14.0, we can collect stats for
volatile tables also. Therefore queries need to be looked
upon for better performance.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by teradata sql assistant?
What is meant by a Highest Cost Plan?
Where is teradata rdbms used?
Explain teradata vs. Redshift?
In the Primary Index, what is the score of AMPs that are actively involved?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
what is object level locking ? where do appear this type of locking ?
Highlight the limitations of TPUMP Utility.
What is the basic syntax for teradata select statement?
If RDBMS is halted what will you do ?
Mention a few of the ETL tools that come under Teradata.
What is a level of granularity of a fact table?
What is basic teradata query language?
What is teradata? Also, list out some of the primary characteristics of teradata.
What is the primary index in teradata?