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
- 19066 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
Highlight the advantages of PPI(Partition Primary Index).
any one answer me how they can analyzing the project using data ware housing?
How many sessions of MAX is PE capable of handling at a particular time?
What is real time and near real time data warehousing?
What is database exceptions in teradata?
Explain the advantages of partitioned primary index in a query?
What do you mean by teradata intelliflex?
What are the updated features of teradata?
What are the functions of a teradata dba?
What is the difference between teradata and basic rdbms?
When tpump is used instead of multiload?
What is the use of fallback?
What is the difference between union and union all in teradata?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
