![]() ![]() I have created a simple script to show what's going on. I checked the results and the end result is exactly the same, so that is no explanation for the performance gain. Using BULK COLLECT and FORALL to minimize the context switches and LIMIT to manage my memory usage.Īnd in my environment this PL/SQL code ran more than twice as fast as the SQL solution. But, curious as I am, I decided to run the same update in a block of PL/SQL code. I always thought (was taught?) that pure SQL was faster than PL/SQL. No problem, I thought, since it is something that will only be run occasionally. I have created a query that does exactly what I want but it takes a lot of time. Otherwise try PL/SQL and if that doesn't work ask for help."
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |