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
- 21162 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
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What do high confidence, low confidence and no confidence mean in explain plan?
What is the purpose of joins in teradata?
What is meant by a Least Cost Plan?
Can you connect multiload from ab initio?
What are the different softwares used with their functions in teradata?
Explain teradata architecture in detail with a diagram.
What is teradata and why it is used?
Highlight the advantages of PPI(Partition Primary Index).
Explain the term 'database' related to relational database management system?
What is called partitioned primary index (ppi)?
Describe the between keyword in teradata?
Describe the set operators in teradata.
Why is the case expression used in teradata?
How to Extract data from multiple legacy systems?
