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:48:09 -0800
Message-ID: <e7534c7b.0202220148.79c76ccc@posting.google.com>

pobox002_at_bebub.com (Martin Burbridge) wrote in message news:<45a06b65.0202211807.8cf4f26_at_posting.google.com>...
> Oops, I misread that as the first select being eqivalent to cur_rec.
>
> So the second is a single statement also. Is it always slow, packages
> take time to validate after recompiling which could be a possibility.
> Martin Burbridge

[...]

Thanks for the answers. I found a good explanantion while searching the web ...

http://www.jlcomp.demon.co.uk/faq/sqlplsql.html

Regards,

Joern

Joern Dinkla
Hamburg, Germany
http://dinkla.net Received on Fri Feb 22 2002 - 03:48:09 CST