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
- 9973 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 high confidence, low confidence and no confidence mean in explain plan?
What is real time and near real time data warehousing?
What are the various etl tools in the market?
Explain the teradata primary index mechanics in detail with a diagram.
how many modules are there in telecome domain?how to explain the architecture?
How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale
How to Extract data from multiple legacy systems?
How many types of joins are there in teradata?
What is meant by a Least Cost Plan?
What tools would you use for that?
How does indexing improve query performance?
What is meant by a Virtual Disk?
Teradata 
