Optimization techniques for PL/SQL

Abstract

The research study proposes the integration and testing of PL/SQL, which can be used in the application of Oracle-based information systems. Oracle is a database system that is used often and highly popular in large-scale operations. The experiment present many studies performed on commands and through comparisons of various techniques, with the best results achieved from the comparison of ten different methods being Using Index, Out Number Technique, and Reducing Sub Query. The results show that the proposed methods are able to increase efficiency by at least 9.88%, up to 732.25%.