Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> benchmarking, which statement is faster
hi all,
has anybody benchmarked or has any idea which of the following statements will execute faster?
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:
thanks. Received on Tue Jul 24 2001 - 14:39:55 CDT