Re: Oracle For Fun

Cris Carampa <cris119_at_operamail.com> wrote in message news:<bv5al1$c6r$1_at_panco.nettuno.it>...
> 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.
>

You're quite right. Daniel probably means some kind of FOR ALL or BULK but insert...select is surely fastest, because it is executed inside of SQL engine. And, of course, it was available long ago, surely in v6, but I think much earlier.

> Perhaps are there performance benefits in using BULK clauses and arrays
> instead?
>
> Kind regards,
Received on Tue Jan 27 2004 - 11:20:05 CST