Global Temp table

Database
N/A

Global Temp table

Hi,

I understand that the GTT have their definition in data dictionary and the data is localised for the user for that session.

But could any one let me know where GTT is used in the real world. With an examlpe

2 REPLIES

Re: Global Temp table

Hi,

GTT can use instead of VT(volatile tables) in BTEQ to improve performance. Because we can not collect stats on VT but we can collect on GTT.

Thanks,

Re: Global Temp table

difference between derived table, global temporary table and volatile table