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
- 21542 Views
- IBM, I also Faced
- E-Mail Answers
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
Highlight the differences between Primary Key and Primary Index.
Difference between star and snowflake schemas?
What is a node in teradata?
What is spool space?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Which is faster fastload or multiload?
Explain the types of join supports by teradata?
What is the purpose of indexes?
What are the design features involved in teradata?
What is the difference between teradata and basic rdbms?
What are the functions of a teradata dba?
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
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is real time and near real time data warehousing?
What do you mean by teradata sql assistant?
