Re: Help ! Performance question : utl_file or sql*loader?

My understanding, when doing something similar is that disabling logging and using /* +append */ when inserting records into new table will allow pl/sql to do inserts about as fast as sql*loader.

However, I'm not sure if utl_file will give as good as read performance, but I don't see why not.

However, if you use sql*loader to insert into temporary table. Then do another set of inserts for final data I'd think your performance would be almost half what doing read/writes once from file to final table.

-greg

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jul 26 2000 - 00:00:00 CDT