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
- 21334 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
How do you create tables? Exact syntax, and create profiles, users in teradata?
Explain the parallel data extension in teradata?
What is primary index and secondary index?
What is the purpose of joins in teradata and what are the available join types?
What are the different design perspectives used in teradata?
What is bteq utility in teradata?
what is sysdba and sysdbc ? which has high priority ?
What do high confidence, low confidence and no confidence mean in explain plan?
Highlight the differences between Primary Key and Primary Index.
What are the string manipulation operators and functions associated with teradata?
What is spool space? Why do you get spool space errors?
What are the components used in smp and massively parallel processing (mpp) machines?
How to eliminate product joins in a teradata sql query?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Comment whether bottleneck is an error or not.
