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: Why would an Insert /*+ append */ be slower than a straight insert?

Re: Why would an Insert /*+ append */ be slower than a straight insert?

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 23 May 2003 19:18:22 +0200
Message-ID: <4ulscv4outh8nsffooldm0hnqpillpjdbd@4ax.com>


On 23 May 2003 04:08:27 -0700, rgaffuri_at_cox.net (Ryan Gaffuri) wrote:

>btw, you mind telling me where in that documentation there is stuff on
>why insert append might be slower? I thought there might be some
>undocumented rules where in some cases its an inferior option.

Actually there are graphs in the Oracle internals course showing it is much faster

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri May 23 2003 - 12:18:22 CDT

Original text of this message

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