Optimizing Cursor Loops in Relational Databases

Surabhi Gupta, Sanket Purandare, Karthik Ramachandra

Loops that iterate over SQL query results are quite common, both in application programs that run outside the DBMS, as well as User Defined Functions (UDFs) and stored procedures t…