What happens if we create and insert/update the data in TEMP tables , Does that data really gets inserted at disk level or at buffer level
Disk
and what happens to this data after completion of the transaction ?
Your choice. See “on conflict” clause of create temp table command.
David J.
