High performance PL/SQL programming
Vamsi Krishna Myalapalli, Bhupati Lohith Ravi Teja · 2015
Performance engineering is a vital aspect in PL/SQL programming, as most of the Database associated applications are built with PL/SQL Code. There subsists many ways of writing PL/SQL statement to retrieve same result set, but the approach which levies minimum impact on DBMS engine is always esteemed. Most commercial transaction scripts are written using PL/SQL code. The proposed idea(s) are envisioned to oblige as tuning utility and benchmark for tuning PL/SQL queries. This paper enunciates different techniques that can reduce time and space complexity of a native SQL query and PL/SQL script. Our analysis reduced the rate of Context switching (an overhead) among SQL engine and PL/SQL engine.