Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 21551 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
Explain teradata vs. Redshift?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What are differences between teradata and ansi session modes in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What are the newly developed features of Teradata?
Highlight the advantages of PPI(Partition Primary Index).
What are the things to be considered while creating secondary index?
What are different table types used in teradata?
Why teradata is used?
What is the difference between union and union all in teradata?
How do you see a ddl for an existing table?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the multiload utility limitations?
What are the available primary index types in teradata.
Different phases of multiload?
