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
- 19617 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
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 do you mean by teradata intellicloud?
What are the updated features of teradata?
what are the uses of fact table and dimension table in banking project?
What can be achieved by using the teradata rdbms?
How many types of joins are there in teradata?
Differentiate database data and data warehouse data?
What is real time and near real time data warehousing?
What is the use of having index on table?
How can bottlenecks be identified?
What do you mean by tpt in teradata?
Difference between stored procedure and macro?
How does hashing happens in teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
Highlight the points of differences between the database and user in Teradata.
