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
- 21076 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / humayun
yes we camn collect statistics on globaltemporary table
wher as we cant on derived and volatile because these table
will be created under spool mempory.and global tempoary
tables will be created to get the intemediate results this
table will be created and dropped as part of the query.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
what is object level locking ? where do appear this type of locking ?
What is a dimension table?
Explain and compare pros and cons of snow flake schemas?
Explain fastload in teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
How do you do backup and recovery in teradata?
Differentiate primary key and partition key?
What are the joins in teradata?
What are the components provided on node?
What is TPD?
What is the purpose of using case expression in teradata?
What is the use of virtual processor connectivity in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What do you mean by caching in teradata?
