Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Overheads in using MERGE statement

Re: Overheads in using MERGE statement

From: Joel Garry <joel-garry_at_home.com>
Date: 21 Apr 2004 15:47:22 -0700
Message-ID: <91884734.0404211447.6fdb37af@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US