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 are the uses of client software involved in teradata?
What is a clique?
Differentiate database data and data warehouse data?
In general, how do you optimze any sql in teradata?
What do you mean by tpt in teradata?
What are the various indexes in teradata?
Explain some differences between mpp and smp?
what are the uses of fact table and dimension table in banking project?
What is real time and near real time data warehousing?
Why managing the data is important?
What is teradata and why it is used?
Explain the advantages of partitioned primary index in a query?
What is meant by a Channel Driver?
What is basic teradata query language?
While creating table my dba has fallback or no fallback in his ddl. What is that?