yes. its possible. And in TD 14.0, we can collect stats for volatile tabl

can we join volatile table with general table an global
temporary table with general table
?

Question Posted / tdguy

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

Please Help Members By Posting Answers For Below Questions

Highlight the points of differences between the database and user in Teradata.

1059

What do you mean by teradata intelliflex?

1058

Explain Teradata performance tuning and optimization?

1121

What are the different methods ot loading a dimension table? A fact table etc?

996

What are different table types used in teradata?

995

What is the use of teradata system software?

1003

Explain the term 'columns' related to relational database management system?

1015

Name the five phases that come under MultiLoad Utility.

947

Highlight the limitations of TPUMP Utility.

1068

In BTEQ, how are the session-mode parameters being set?

1103

In Teradata, how do we Generate Sequence?

1000

Explain the teradata primary index mechanics in detail with a diagram.

929

Where is teradata rdbms used?

1054

How to load specific no.of records using bteq, or fastload,or multiload

1707

What is teradata? Also, list out some of the primary characteristics of teradata.

1002