Performance: Case insert vs Update

[craig322]

Has anyone done any testing on the performance differences
between using a case statement inside of an insert statement
or just using an update once the table is populated.

I have an insert that I am running currently which is taking 5 + hours. I am using a case statement inside of
it and am looking for ways to decrease the overall time.

TIA

Craig

 

[seidub]

Updating or inserting into populated tables in Teradata can be very slow ... Try inserting into an empty table 1st and then merge your newly inserted table with the populated table.