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
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
In Teradata, how do we Generate Sequence?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What is a node in teradata? Explain
What are the available join types in teradata?
if collect stats but it show low confidence why?
Explain the term 'row' related to relational database management system?
What are the things to be considered while creating secondary index?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is meant by a dispatcher?
What are the functions of a teradata dba?
What are the design features involved in teradata?
What do you mean by ttu in teradata?
What is the multi-insert?
What is a three-tier data warehouse?
how do you manage the production space. what are the proactive methods you can take ?