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
- 19007 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ankal
As Per my knowledge i am expecting this is true.Anybody got better answers plzzzz post.
No.Not possible to take collect stats on Derived Volitable because this tables structure will not store in data dictionary it will store in spool space so not possible to take collect stats on this tables.But possible to take collect stats on Global Temporary table because this table structure will store in DD(data dictionary)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain PDE.
Explain the term 'columns' related to relational database management system?
Can we collect statistics on table level?
What is the purpose of joins in teradata and what are the available join types?
Why does varchar occupy 2 extra bytes?
How is the teradata different from oracle?
Highlight the differences between Primary Key and Primary Index.
What is meant by a Channel Driver?
Explain and compare pros and cons of start schemas?
Explain the parallel data extension in teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Which is more efficient group by or distinct to find duplicates?
What do you mean by teradata intellicloud?
What is called partitioned primary index (ppi)?
Different phases of multiload?
