Help me understand how the global temporary table works.
I have a process that will be streaming and requires that the data is visible only to this stream session. Therefore, we have chosen a global temporary table.
Is it better to leave the global temporary table undeletable after all threads have completed, or is it advisable to delete the table. The challenge of this process can occur once or twice a day.
It takes about 4 tables
source
share