Re: Oracle For Fun

Giganews Newsgroups
Subject: Re: Oracle For Fun
Posted by:  Cris Carampa (cris1…@operamail.com)
Date: Tue, 27 Jan 2004

Daniel Morgan wrote:

> Everyone using 8i+ features should be able to improve the performance of
> this by at least 5X.

I always thought the best way to do that was:

INSERT INTO t1
  (owner, object_name, subobject_name, object_id,
  data_object_id, object_type, created, last_ddl_time,
  timestamp, status, temporary, generated, secondary)
select
  x.owner, x.object_name, x.subobject_name, x.object_id,
  x.data_object_id, x.object_type, x.created,
  x.last_ddl_time, x.timestamp, x.status, x.temporary,
  x.generated, x.secondary
from
  all_objects x ;

But since this construct was already available in Oracle7 I'm surely wrong.

Perhaps are there performance benefits in using BULK clauses and arrays
instead?

Kind regards,

--
Cris Carampa (spamto:cris1…@operamail.com)
"Welcome to the new world order
  Families sleepin' in their cars in the southwest
  No home no job no peace no rest" (Bruce Springsteen)

Replies

In response to

Oracle For Fun posted by Daniel Morgan on Mon, 26 Jan 2004