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
Answer Posted / humayun
yes we camn collect statistics on globaltemporary table
wher as we cant on derived and volatile because these table
will be created under spool mempory.and global tempoary
tables will be created to get the intemediate results this
table will be created and dropped as part of the query.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is oltp?
Why managing the data is important?
How is MLOAD Teradata Server restarted after execution?
How to view every column and the columns contained in indexes in teradata?
What are the functions involved in shared information architecture?
How to find duplicates in a table?
What do you mean by teradata intelliflex?
Comment whether bottleneck is an error or not.
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Different phases of multiload?
Highlight a few of the advantages that ETL tools have over Teradata.
how many modules are there in telecome domain?how to explain the architecture?
What is the purpose of using case expression in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com