benchmarking, which statement is faster

[Quoted] hi all,

[Quoted] [Quoted] has anybody benchmarked or has any idea which of the [Quoted] following statements will execute faster?

1. INSERT INTO TABLE_X (field1, field2, field3,
   ...
   ...
   ...
   fieldn) SELECT source_field1, source_field2, source_field3, ... ... ... source_fieldn) FROM TABLE_Z, TABLE_A WHERE xx = yy AND zz = aa;
2. CURSOR my_cursor IS SELECT source_field1, source_field2, source_field3, ... ... ... source_fieldn) FROM TABLE_Z, TABLE_A WHERE xx = yy AND zz = aa;

   my_record my_cursor%rowtype;

   OPEN my_cursor;
   LOOP

       FETCH my_cursor INTO my_record;
       EXIT WHEN my_cursor%NOTFOUND;

       INSERT INTO TABLE_X (field1,
                         field2, 
                         field3,


                         ...

                         ...

                         ...

                         fieldn)
           VALUES (      my_cursor.source_field1,
                         my_cursor.source_field2,
                         my_cursor.source_field3,


                         ...

                         ...

                         my_cursor.source_fieldn);

   END LOOP;    CLOSE my_cursor;

Note:

1. The select statements are the same.
2. source_field[1..n] can be a simple field from a table or the value returned by the invocation of a database function.

thanks. Received on Tue Jul 24 2001 - 21:39:55 CEST