Interested to Buy Any Domain ? << Click Here >> for more details...
Can we take collect stats on Dervied Tables and Volitable
tables,
What is Golabal Temporary table what is the use of this
Golabal Temporary table ,When we create any kind table in
Teradata it will show in Golabal Temporary table
- 6 Answers
- 21304 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / humayun
yes we camn collect statistics on globaltemporary table
wher as we cant on derived and volatile because these table
will be created under spool mempory.and global tempoary
tables will be created to get the intemediate results this
table will be created and dropped as part of the query.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How do you set the session mode parameters in bteq?
How to eliminate product joins in a teradata sql query?
What is meant by a Least Cost Plan?
What is the difference between fastload and multiload?
While creating table my dba has fallback or no fallback in his ddl. What is that?
During the Display time, how is the sequence generated by Teradata?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What is logical data model?
What is the maximum number of dml can be coded in a multiload script?
What is a node in teradata?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What are the functions performed by bynet?
What are the various etl tools in the market?
Why is the case expression used in teradata?
What exactly do you know about catching in teradata?
