Re: For temporary tables; truncate vs on commit delete all

2023-03-22 Thread Laurenz Albe
On Wed, 2023-03-22 at 11:59 +, Jim Vanns wrote: > Does anyone have any idea which is generally better (by better I mean > most efficient/quickest!) in this simple scenario? I have a temporary > table which I wish to retain for the duration of a long-running > session. However, for each transact

For temporary tables; truncate vs on commit delete all

2023-03-22 Thread Jim Vanns
Does anyone have any idea which is generally better (by better I mean most efficient/quickest!) in this simple scenario? I have a temporary table which I wish to retain for the duration of a long-running session. However, for each transaction it must be purged. So, is it better to; a) Always CREAT