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
- 21302 Views
- IBM, I also Faced
- E-Mail Answers
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 can be achieved by using the teradata rdbms?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What are the steps involved in the process flow of the sql statement through channel attached system?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Why teradata is used?
What are the various indexes in teradata? Why are they preferred?
What tools would you use for that?
Explain the term 'tables' related to relational database management system?
Difference between multiload and tpump?
What is difference between user and database in teradata?
What is the purpose of joins in teradata and what are the available join types?
What is meant by a Clique?
Is multi insert ansi standard?
Explain the advantages of partitioned primary index in a query?
