Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL performance question
Hi all,
Just out of curiosity, I'd like to get your opinion on the following
scenario:
Lots of data (i.e. 2 million records) are periodically loaded into the db
through SQL Loader. Unfortunately, each record needs to be tweaked before
will eventually be saved. Would it be faster to have an on-insert trigger do
this at record level or to have a procedure that will run once all records
are stored in the table?
Regards,
Marcel
Received on Wed May 12 2004 - 16:52:53 CDT