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
Answer Posted / jai
We can take collect stats for volatile table for version
6.1.2 onwards Golabal Temporary table is usable for
particular session only the table defination is avaialble
in data dictionary and it takes space temporary
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is the difference between union and union all in teradata?
What's the difference between timestamp (0) and timestamp (6)?
How to run a query in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is the purpose of using case expression in teradata?
Explain the parallel data extension in teradata?
What are the primary characteristics of the Teradata.
What is a dimension table?
What is the command in bteq to check for session settings ?
In general, how do you optimze any sql in teradata?
What is teradata? What are some primary characteristics of teradata?
Steps to create a data model?
What are aggregate tables? How do you design them using teradata?
Why do you get spool space errors? How do trouble-shoot them?