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

Greg,

   Thanks for clarifying that the utl_file reads might be as good as sql*loader reads if not better. I was thinking that sql*loader direct load (not the conventional load), a select on temporary table and a bunch of pl/sql inserts might outperform utl_file reads and pl/sql parses and pl/sql inserts. If there is not a significant penalty in utl_file reads then I guess I will stick with the utl_file approach.

Thanks a bunch
Prahalad
(ppateel_at_iname.com) Received on Wed Jul 26 2000 - 00:00:00 CDT