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
- 21338 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 can we analyze the locks ?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is TPD?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Is multi insert ansi standard?
What are the different functions included in the server software?
When tpump is used instead of multiload?
How to select first n records in teradata?
What is teradata? What are some primary characteristics of teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Difference between stored procedure and macro?
Explain teradata utilities?
Explain the term 'columns' related to relational database management system?
Describe primary index in teradata. And what are the available primary index types?
What is the purpose of indexes?
