Oracle Enterprise Stage - Insert statement using Upsert
Posted: Wed Feb 01, 2012 9:14 am
Hi,
We have an insert statement and we are using the Write Method as Upsert in Oracle Enterprise Stage.
My Question is - What is the difference between using the upsert mode - "User Defined Update Only" mode and writing the Insert statement here against using the "User Defined Update & Insert" mode where we basically do not update anything by giving something like 1=2 in the where clause and only use the Insert part.
Is there a performance impact by using the Update mode to actually insert against using the insert mode for insert, as both work but which is the correct & efficient way?
Thanks
We have an insert statement and we are using the Write Method as Upsert in Oracle Enterprise Stage.
My Question is - What is the difference between using the upsert mode - "User Defined Update Only" mode and writing the Insert statement here against using the "User Defined Update & Insert" mode where we basically do not update anything by giving something like 1=2 in the where clause and only use the Insert part.
Is there a performance impact by using the Update mode to actually insert against using the insert mode for insert, as both work but which is the correct & efficient way?
Thanks