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
- 19047 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 are the uses of fact table and dimension table in banking project?
any one answer me how they can analyzing the project using data ware housing?
what are the day to day activities of teradata DBA ?
What is the opening step in basic teradata query script?
What is the use of teradata system software?
Can we collect statistics on table level?
List out some of the primary characteristics of teradata.
Different phases of multiload?
What is the maximum number of dml can be coded in a multiload script?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
what is sysdba and sysdbc ? which has high priority ?
What are the various reporting tools in the market?
What is multi insert?
How is the teradata different from oracle?
What are the steps involved in the process flow of the sql statement through channel attached system?
