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
- 19046 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / jai
We can take collect stats for volatile table for version
6.1.2 onwards Golabal Temporary table is usable for
particular session only the table defination is avaialble
in data dictionary and it takes space temporary
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Syntax for case when statement?
Explain BYNET.
What happens when a node suffers a downfall?
Why does varchar occupy 2 extra bytes?
Explain the parallel data extension in teradata?
What are the functions performed by bynet?
What is a sparse index?
What do high confidence, low confidence and no confidence mean in explain plan?
During the Display time, how is the sequence generated by Teradata?
Explain the term 'database' related to relational database management system?
Describe the set operators in teradata.
How many types of joins are there in teradata?
What do you mean by ttu in teradata?
How will you solve the problem that occurs during update?
What is oltp?
