|
-
SQL Plus is not faster than PL/SQL. It is about time to understand that SQL and SQL Plus are different things. :-P
The update-select is faster since it is called bulk operation. No context switches between PL/SQL engine and SQL engine occurs.
If you make that update-select into a PL/SQL procedure it will not perform significantly worse than the single update-select statement.
About the control, yes that's true. If you want to commit on each 1000 rows, or if you want to see exactly update of which row fails and why, then probably that will help, although 10g has some nice features in the bulk operations which helps a lot here BUT without any commit into the loop all you have with the loop is that you will print out the exact row that failed
Cheers
Last edited by Bore; 08-23-2007 at 09:50 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote