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
- 21303 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vinay sir,dwh technologies,ame
Small correction guys for the above answers:
We can collect statitics on volatile tables in TEARADATA-13.
Just try at home.
Derived tables any way we can collect.
Volatile tables life time with in the session(Data and
Structure).
Global temporary tables life time accross sessions
(definition only).
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / yuvaevergreen
No for volatile and derived tables and yes for golobal
tables. Global tables are temp tables like volatile tables
but unlike volatile tables, their definitions are retained
in dd. It is used whenever there is a need for a temporary
table with same table definition for all users.
| Is This Answer Correct ? | 7 Yes | 5 No |
Answer / ankal
As Per my knowledge i am expecting this is true.Anybody got better answers plzzzz post.
No.Not possible to take collect stats on Derived Volitable because this tables structure will not store in data dictionary it will store in spool space so not possible to take collect stats on this tables.But possible to take collect stats on Global Temporary table because this table structure will store in DD(data dictionary)
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / tdguy
In TD14.0, stats can be collected for volatile tables also.
GTTs are stored in temporary space and definition alone is
retained across sessions. Temporary tables are used, when
there is a need to store some aggregate results of rows for
further sql processing. It also increases the need to join
big tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / 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 |
Highlight a few of the advantages that ETL tools have over Teradata.
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 the use of teradata system software?
Explain the term 'row' related to relational database management system?
During the Display time, how is the sequence generated by Teradata?
How to view every column and the columns contained in indexes in teradata?
Difference between multiload and tpump?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me
what is single value and Multivalue ?
What are the different softwares used with their functions in teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is partitioned primary index (ppi)?
Teradata 
