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
- 19067 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
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the different table types supported by teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is meant by a Parsing Engine?
Explain fastload in teradata?
What are the components provided on node?
How can you track login parameters of users in teradata?
What is the difference between fastload and multiload? Which one is faster?
Explain the new features of teradata?
What are the different functions included in the server software?
What is the use of having index on table?
Explain teradata architecture in detail with a diagram.
What is real time and near real time data warehousing?
Explain vproc in teradata?
Difference between multiload and tpump?
