Re: Differences in performance of an INSERT-statement in SQL and PL/SQL

From: Joern Dinkla <joern.dinkla_at_promatis.de>
Date: 22 Feb 2002 01:15:48 -0800
Message-ID: <e7534c7b.0202220115.5a3e65c1@posting.google.com>

"Keith Boulton" <kboulton_at_ntlworld.com> wrote in message news:<KWed8.4967$H43.590760_at_news11-gui.server.ntli.net>...
> You are replacing literals with bind variables. This can change the access
> path.
>
> It is also not clear when you say 4000 rows you mean a single insert is
> inserting 4000 rows or the insert is being run 4000 times.
>

[...]

A single insert is inserting 4000 rows.

Regards,

Joern Received on Fri Feb 22 2002 - 03:15:48 CST

This message: [ Message body ]
Next message: Alex Hepp: "Re: rotation table in 90 degree - help"
Previous message: Thomas Fricker: "minimum Hardware requirements for Oracle 9i"
In reply to: Keith Boulton: "Re: Differences in performance of an INSERT-statement in SQL and PL/SQL"
Next in thread: Martin Burbridge: "Re: Differences in performance of an INSERT-statement in SQL and PL/SQL"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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