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

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

Question Posted / kk

4 Answers
8986 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / nitin bansal

yes we can

Is This Answer Correct ?

1 Yes

0 No

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

Answer / sri

can u pls give the syntax.....

Is This Answer Correct ?

0 Yes

0 No

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

Answer / rkraju

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

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

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

Post New Answer