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
- 21058 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 is primary index and secondary index?
What do you mean by ttu in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
In BTEQ, how are the session-mode parameters being set?
In the Primary Index, what is the score of AMPs that are actively involved?
What are some primary characteristics of teradata?
What are the newly developed features of Teradata?
How to eliminate product joins in a teradata sql query?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Which is more efficient group by or distinct to find duplicates?
What is stored procedure in teradata?
Explain teradata architecture in detail with a diagram.
What is difference between user and database in teradata?
What is a clique?
What are the available join types in teradata?
