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
- 21550 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
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
Differentiate database data and data warehouse data?
What is spool space?
How will you solve the problem that occurs during update?
What are types of partition primary index (ppi) in teradata?
Name the five phases that come under MultiLoad Utility.
Steps to create a data model?
What is difference between user and database in teradata?
How can bottlenecks be identified?
What interface is used to connect to windows based applications?
What do you mean by teradata sql assistant?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Explain vproc in teradata?
What are the available join types in teradata?
how can we analyze the locks ?
