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
- 21294 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
Highlight the differences between Primary Key and Primary Index.
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What are teradata utilities?
Explain amp in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Write a program to show the parser component used in teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What do high confidence, low confidence and no confidence mean in explain plan?
What happens in a conflict? How do you handle that?
What do you mean by teradata intellicloud?
Can you connect multiload from ab initio?
Highlight the limitations of TPUMP Utility.
List out all forms of LOCKS that are available in Teradata.
What is the opening step in basic teradata query script?
What is the purpose of indexes?
