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
- 19077 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
How is the teradata different from oracle?
Write a program to show the parser component used in teradata?
Which is faster fastload or multiload?
What are the available primary index types in teradata.
In BTEQ, how are the session-mode parameters being set?
List the logical and conditional operators that are used with teradata along with their meanings?
In the Primary Index, what is the score of AMPs that are actively involved?
Explain the parallel data extension in teradata?
What are the updated features of teradata?
What is a node in teradata? Explain
What is spool space?
Why managing the data is important?
Mention a few of the ETL tools that come under Teradata.
Can we collect statistics on multiple columns?
What is meant by a Virtual Disk?
