Global Temporary Tables

[coolboy98699]

Sir i have a bit idea on GTT

means like 'on commit preserve rows' and 'on commit delete rows'

But i have doubt

1.in which situation we will use
2.Is there any perfomance gain by using them

Kindly reply !!!

Thank you very much

[Tim...]

Hi.

If you want the data in the table for the life of your session, then you should use preserve, or the data will be lost on the first commit. If you are happy to throw away the data on commit, then use that. You are not going to notice a difference in performance, but freeing up unused temp space is a good idea as it is then available for other sessions to use.

Cheers

Tim...

[coolboy98699]

Sir

Thank you very much for your reply

[Tim...]