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
- 19619 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 different functions performed in development phase?
How many codd's rules are satisfied by teradata database?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
If RDBMS is halted what will you do ?
What is the purpose of upsert command?
During the Display time, how is the sequence generated by Teradata?
What are the various etl tools in the market?
List out some of the primary characteristics of teradata.
Explain PDE.
What do you mean by ttu in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
if collect stats but it show low confidence why?
What are the various indexes in teradata?
What are the functions of a teradata dba?
What is multi insert?
