Which is faster for millions of records: Permanent Table or Temp Tables?
I have to use it only for 15 million records. After processing is complete, we delete these records.
Which is faster for millions of records: Permanent Table or Temp Tables?
I have to use it only for 15 million records. After processing is complete, we delete these records.
Permanent table is faster if the table structure is to be 100% the same since there's no overhead for allocating space and building the table.
Temp table is faster in certain cases (e.g. when you don't need indexes that are present on permanent table which would slow down inserts/updates)