Update vs Delete/Insert

Asked Jun 17 '21 at 04:03

Active Jun 17 '21 at 04:03

Viewed 330 times

I looked at this thread: In SQL, is UPDATE always faster than DELETE+INSERT?, but it didn't seem to answer the question as everyone takes side on both.

Let's pretend I have a table with 100 columns and 50 million rows of data. No indexes No constraints

Would it be faster to truncate/insert 50 million rows or simply do an update based on column or combination of columns?

asked Jun 17 '21 at 04:03

[This might help](https://stackoverflow.com/a/29141391/10209642) Not exactly new but is still valid. – Saatvik Ramani Jun 17 '21 at 04:10
1

Very dependent on what percentage of the table is being changed. But why would you have a table with no indexes? – Charlieface Jun 17 '21 at 08:55
There are no absolute "answers" with respect to performance. The only way to know is to implement both and test/evaluate them. – SMor Jun 17 '21 at 11:34
I joined a company where they are growing their data department. Nobody knows how to use indexes other than me. – Chicken Sandwich No Pickles Jun 17 '21 at 21:05

0 Answers0