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
- 19024 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
What are the uses of bynets in multi-node systems?
Explain and compare pros and cons of snow flake schemas?
How to Extract data from multiple legacy systems?
Explain the types of join supports by teradata?
How to view every column and the columns contained in indexes in teradata?
Highlight the advantages of PPI(Partition Primary Index).
What is teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is teradata? What are some primary characteristics of teradata?
How to identify ppi columns?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is the syntax for case when statement?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What are different table types used in teradata?
What's the difference between timestamp (0) and timestamp (6)?
