Home » SQL & PL/SQL » SQL & PL/SQL » Merge performance
Merge performance [message #275145] Thu, 18 October 2007 08:57 Go to next message
Messages: 3
Registered: April 2006
Location: Duesseldorf, Germany
Junior Member

when i merge a table with 600.000 new entries it takes about 3 to 4 minutes on a SATA, one CPU server. I only have text data, no blobs. does it sound somehow reasonable ?

This should be 600.000 inserts with a full table scan on two tables. A sqlldr statement with 600.000 inserts on the same server takes about 17 seconds. OK, a merge writes redo-logs but ...

How long does a merge in your environments run ?

Th@nx in advance,

Re: Merge performance [message #276384 is a reply to message #275145] Thu, 25 October 2007 01:22 Go to previous message
Messages: 7062
Registered: December 2001
Senior Member
Pfew, not an easy question. Your guess is as good as mine. But there's a fair chance that your SQL statement is not optimized. Why MERGE? Why not INSERT? You don't talk about updates. And SQL*Loader is a tool that does one thing: load data. It is designed to do that fast.

Previous Topic: Build SQL Statement then Execute
Goto Forum:

Current Time: Thu Jul 27 02:00:37 CDT 2017

Total time taken to generate the page: 0.10647 seconds