Re: Sqlldr versus inserts
- From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- To: nigel_cl_thomas@xxxxxxxxx
- Date: Mon, 12 Mar 2007 07:41:28 -0600
John,
Remember you can use the /*+ APPEND */ hint on the inserts, so you will be
getting the equivalent of direct path insert. Overall, the performance may
not be as high, since you may experience various delays (network, client
server, etc.). However, performance may be adequate. Remember the goal is
get the data loaded when it is required, not necessarily match your current
performance. I'm guessing the developers have other reasons for suggesting
this change.
Dennis Williams
Other related posts: