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
- 21157 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 do you verify a complicated sql?
How many sessions of MAX is PE capable of handling at a particular time?
How can bottlenecks be identified?
Explain the term 'primary key' related to relational database management system?
What is database exceptions in teradata?
What are the string manipulation operators and functions associated with teradata?
What are the joins in teradata?
Highlight the points of differences between the database and user in Teradata.
Explain the types of join supports by teradata?
Explain vproc in teradata?
Why do you get spool space errors? How do trouble-shoot them?
How do you set the session mode parameters in bteq?
What do you mean by parsing?
What is the command in bteq to check for session settings ?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
