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 |
IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance
2 Answers Cap Gemini, IBM, Infosys,
Explain the term 'columns' related to relational database management system?
what is referential constraints?how do you implement RI in teradata?
What is the basic syntax for teradata select statement?
What is stored procedure in teradata?
What is the purpose of joins in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
How a Referential integrity is handled in Teradata?
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
What does sleep function does in fast load?
Increasing no of amps will increase performance. Is this true?
What is a dimension table?