What is the difference between Global temporary tables and Volatile temporary tables?
Submitted by: AdministratorGlobal Temporary tables (GTT) -
1. When they are created, its definition goes into Data Dictionary.
2. When materialized data goes in temp space.
3. thats why, data is active upto the session ends, and definition will remain there upto its not dropped using Drop table statement.
If dropped from some other session then its should be Drop table all;
4. you can collect stats on GTT.
Volatile Temporary tables (VTT) -
1. Table Definition is stored in System cache
2. Data is stored in spool space.
3. thats why, data and table definition both are active only upto session ends.
4. No collect stats for VTT.
Submitted by: Administrator
1. When they are created, its definition goes into Data Dictionary.
2. When materialized data goes in temp space.
3. thats why, data is active upto the session ends, and definition will remain there upto its not dropped using Drop table statement.
If dropped from some other session then its should be Drop table all;
4. you can collect stats on GTT.
Volatile Temporary tables (VTT) -
1. Table Definition is stored in System cache
2. Data is stored in spool space.
3. thats why, data and table definition both are active only upto session ends.
4. No collect stats for VTT.
Submitted by: Administrator
Read Online Teradata Job Interview Questions And Answers
Top Teradata Questions
☺ | What is stored procedure in Teradata? |
☺ | What is the difference between start schma and Fsldm? |
☺ | What are the enhanced features in Teradata V2R5 and V2R6? |
☺ | How teradata makes sure that there are no duplicate rows being inserted when its a SET table? |
☺ | What is an optimization and performance tuning and how does it really work in practical projects? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |