RE: Rollback per transaction %:73 %?
- From: Flado <vandreev@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 8 Aug 2008 15:15:50 +0200
- *From*: Tanel Poder <tanel.poder.003@xxxxxxx>
- *To*: "'Wiktor Moskwa'" <wmoskwa@xxxxxxxxxxxx>
- *Date*: Fri, 08 Aug 2008 19:22:47 +0800
Hi Wiktor,
In theory you should choose the approach based on which case occurs mostly -
if you are expecting 99% of inserts to fail as corresponding rows already
exist in database (and need to be updated instead) then better start with
update and if 0 rows found then insert. And vice versa, if you expect to
insert 99% of rows and only update 1% then better start with insert (and if
it fails then update).
-- In theory, you sould choose MERGE in such cases, no?
Other related posts:
