can we join volatile table with general table an global
temporary table with general table
?
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 |
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.
can we load 10 millions of records into target table by using tpump?
any one answer me how they can analyzing the project using data ware housing?
What is meant by a Parsing Engine?
Highlight the need for Performance Tuning.
how to delete duplicate records in multi set table without using any tables
2 Answers Accenture, Nest, South Nests Software Solution, Spiro Solutions,
Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???
1.what is activity count? 2.what is skew factor? how it's working explain brefily
Difference between star and snowflake schemas?
In the Primary Index, what is the score of AMPs that are actively involved?
How to view every column and the columns contained in indexes in teradata?
what is referential constraints?how do you implement RI in teradata?