Interested to Buy Any Domain ? << Click Here >> for more details...
can we join volatile table with general table an global
temporary table with general table
?
- 4 Answers
- 10030 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 |
In the Primary Index, what is the score of AMPs that are actively involved?
Explain Teradata performance tuning and optimization?
How to copy 1 million records from one DB to another, Which is effective interms of performance?
How to relege locks in fastload and multiload? example?
What does sleep function does in fast load?
How do you set the session mode parameters in bteq?
1.what is activity count? 2.what is skew factor? how it's working explain brefily
In Teradata, how do we Generate Sequence?
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
why should we go Teradata over Oracle,what is the main differences?
How is MLOAD Teradata Server restarted after execution?
Explain teradata utilities. What is multiload, fast load, tpump?
Teradata 
