With an empty table this operation is fast but as the number of rows in the table went into hundreds of thousands, the time grew to about 10-15 seconds for an update of 1000 rows. When trying out ...

With Type 1, a fact row is simply updated in place. And with Type 2, the original fact row is end-dated and flagged as logically deleted, then a replacement row is inserted. In doing these Type 1 & ...