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
- 21537 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 are the functions of a Parser?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
How many codd's rules are satisfied by teradata database?
What is real time and near real time data warehousing?
Explain the term 'tables' related to relational database management system?
What are the different methods ot loading a dimension table? A fact table etc?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is bteq script in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Difference between star and snowflake schemas?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What are the design features involved in teradata?
How to eliminate product joins in a teradata sql query?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What are the various reporting tools in the market?
