DATA Step, Macro, Functions and more

Oracle PL/SQL "forall" inserts and SAS multi-inserts

Reply
Contributor
Posts: 55

Oracle PL/SQL "forall" inserts and SAS multi-inserts

I'm curious whether SAS Multi-Insert technology actually invokes something similar to PL/SQL "forall" inserts. The speed is very similar on systems that I'm using. Both are almost the same speed assql*loader
Super User
Posts: 5,441

Re: Oracle PL/SQL "forall" inserts and SAS multi-inserts

This specific question is best answered by a SAS/ACCESS developer.
Try to get an answer via tech support, or if you attend Global Forum - grab someone at the demo stations.

In my mind, there are some situations when bulkload is faster, especially for really large loads.

/Linus
Data never sleeps
Contributor
Posts: 55

Re: Oracle PL/SQL "forall" inserts and SAS multi-inserts

We have found that "forall" out performs bulkload in our situation. We ended up making Oracle "forall" Procedures to call from SAS.
Ask a Question
Discussion stats
  • 2 replies
  • 170 views
  • 0 likes
  • 2 in conversation