Table vs Temp Table Performance

2020-06-12 03:47发布

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.

7条回答
狗以群分
2楼-- · 2020-06-12 04:23

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)

查看更多
登录 后发表回答