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
if collect stats but it show low confidence why?
Highlight all the modes that are present under Confidence Level.
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Explain the term 'primary key' related to relational database management system?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What do you mean by teradata intellicloud?
What type of indexing mechanism do we need to use for a typical data warehouse?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is basic teradata query language?
In Teradata, what is the significance of UPSERT command?
What is bteq script in teradata?
How can you track login parameters of users in teradata?
Syntax for case when statement?
What are types of partition primary index (ppi) in teradata?
What are the multiload utility limitations?