Re: insert/update performance

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 08 Jul 1999 21:02:10 +0800
Message-ID: <3784A152.22C@yahoo.com>

Norris wrote:
>
> May I know if there is any performance difference for the following two
> statement (with and without subquery):
>
> insert into table1 select 'a','b' from dual;
>
> insert into table1 values ('a','b');

I would go with values...

You will get an extra call to the db to do the select...

From what I've seen at a lot of places, people over use 'select ... from dual' especially in PL/SQL...

Things like 'select function_name into x from dual' instead of x := function_name etc etc etc

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jul 08 1999 - 08:02:10 CDT