Oracle enterprise stage Upsert not running efficiently
Posted: Tue Nov 04, 2008 10:13 am
I currently have a job writing data from sql server to oracle10g.
I'm using Oracle Enterprise stage and selected the option "Upsert" and "Update then Insert".
With that combination the data takes forever to get loaded with speed of 3 rows/sec.
When I changed the option to "Insert then Update" it rans extremely quick with a speed of 12000 rows/sec.
The key column checked for Update is CCY_FROM and the table does not have any indexes.
How can use the option "Update then Insert" efficiently in this case?
Thanks!
I'm using Oracle Enterprise stage and selected the option "Upsert" and "Update then Insert".
With that combination the data takes forever to get loaded with speed of 3 rows/sec.
When I changed the option to "Insert then Update" it rans extremely quick with a speed of 12000 rows/sec.
The key column checked for Update is CCY_FROM and the table does not have any indexes.
How can use the option "Update then Insert" efficiently in this case?
Thanks!