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
- 10331 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 do you mean by teradata intellicloud?
What is teradata? What are some primary characteristics of teradata?
What are default access rights in teradata? What explicit right can be given to a user?
how do you manage the production space. what are the proactive methods you can take ?
In Teradata, how do we Generate Sequence?
can we join volatile table with general table an global temporary table with general table ?
Highlight a few of the important components of Teradata?
What are the steps to create a data model?
why varchar takes 2 extra bytes?
While creating table my dba has fallback or no fallback in his ddl. What is that?
how teradata fetches a row from primary index table?
List out teradata data types?
Teradata 
