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
- 21304 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
How to view every column and the columns contained in indexes in teradata?
Explain teradata utilities?
What are the multiload utility limitations?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is meant by a Virtual Disk?
Explain the term 'foreign key' related to relational database management system?
What are the functions of a teradata dba?
What do high confidence, low confidence and no confidence mean in explain plan?
What is a node in teradata?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is TPD?
What are the different methods ot loading a dimension table? A fact table etc?
In BTEQ, how are the session-mode parameters being set?
What is bteq script in teradata?
