can we join volatile table with general table an global
temporary table with general table
?
- 4 Answers
- 9324 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
yes we can join volatile to general table;
>> first we create volatile table
syntax:
create volatile table vt1(x int,y int)on commit preserve rows;
>> we can create general table
syntax:
create table t1(x int,y int,z int);
>>now we can join volatile table and general table
Eg:
select a.x,b.x from vt1 a,t1 b where a.x=b.x;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What is Join Index in TD and How it works?
what are the file sizes in your project?
What is teradata? What are some primary characteristics of teradata?
What is the diffrence between Multiload & Fastload interms of Performance?
Increasing no of amps will increase performance. Is this true?
Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq
Hash collision?
What do you mean by teradata intelliflex?
What is the Maximum number of volatile tables that can be created?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Give some points about Teradata Viewpoint ?
What is a node in teradata? Explain
Teradata 
