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
- 19621 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vinay sir,dwh technologies,ame
Small correction guys for the above answers:
We can collect statitics on volatile tables in TEARADATA-13.
Just try at home.
Derived tables any way we can collect.
Volatile tables life time with in the session(Data and
Structure).
Global temporary tables life time accross sessions
(definition only).
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the difference between teradata and oracle?
What is stored procedure in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Explain teradata architecture in detail with a diagram.
What happens in a conflict? How do you handle that?
What are different table types used in teradata?
What do you mean by teradata intellicloud?
What is the purpose of joins in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Is multi insert ansi standard?
What is spool space? Why do you get spool space errors?
What is meant by a Least Cost Plan?
Can you connect multiload from ab initio?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
