Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Overheads in using MERGE statement
subramanianl_at_coolgoose.com (Subbu) wrote in message news:<5453a1e4.0404201459.bd3c0cc_at_posting.google.com>...
> Could anyone tell me the overheads involved in inserting/updating
> records using MERGE statement and normal DML statements if any.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c16sqlpl.htm#432 for the basics.
http://otn.oracle.com/products/oracle9i/daily/dec11.html for examples.
http://otn.oracle.com/products/oracle9i/pdf/dss_enviroment_9i.pdf for Oracle idea of the performance gain with specific percentages for a specific test.
jg
-- @home.com is bogus. Heck, I've seen better than this: http://www.interactivetools.com/staff/dave/damons_office/Received on Wed Apr 21 2004 - 17:47:22 CDT