Why is the INSERT Statement Slow? Understanding ‘db file sequential read’ Waits
Some weeks ago, a client called complaining about a slowness during its load in a table. The scenario it was pretty simple: They are loading the table using the INSERT statement for each agency (agency_id), with thousands of records for each agency. They complained that…
Disclaimer
My postings reflect my own views and do not necessarily represent the views of my employer, Accenture.