4 ms·
By "load" I'm pretty sure they mean "insert initial data into an empty table." So a different use case. In ETL work, for example, it's not uncommon to truncate
by gmfawcett 6y ago
By "load" I'm pretty sure they mean "insert initial data into an empty table." So a different use case.
In ETL work, for example, it's not uncommon to truncate and reload source and staging tables on each batch run. So the tip would be helpful in those scenarios, more than in an OLTP case (insert this record, update that one).