Performance Analysis of PL/SQL Query Optimization Techniques

Optimization in PL/SQL Programming is the preeminent aspect for database related applications built using PL/SQL code. PL/SQL statement/Query can be written in different ways for fetching the same output, but the most suitable technique should be considered when performance is a crucial factor, sinc...

Full description

Saved in:
Bibliographic Details
Published in:2019 6th International Conference on Computing for Sustainable Global Development (INDIACom) pp. 280 - 285
Main Authors: Kumar, Naveen, Kumaran, G Mayil Muthu, Kaur, Deepjot
Format: Conference Proceeding
Language:English
Published: Bharati Vidyapeeth, New Delhi. Copy Right in Bulk will be transferred to IEEE by Bharati Vidyapeeth 01.03.2019
Subjects:
Context Switch
Electronics packaging
Engines
Memory management
Optimization
Optimizer
Performance analysis
Performance evaluation
PGA Memory
PL/SQL
Query processing
Real-time systems
Time complexity
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Optimization in PL/SQL Programming is the preeminent aspect for database related applications built using PL/SQL code. PL/SQL statement/Query can be written in different ways for fetching the same output, but the most suitable technique should be considered when performance is a crucial factor, since processing time of the query may have significant variance, starting from a fraction of a second ending to hours, depending upon the method preferred. The main aim of query optimization is to find a solution that processes a specific query in minimum optimum time duration. This paper articulates different ways to optimize the performance of SQL queries and PL/SQL scripts by reducing the time complexity and number of context switches between SQL Engine and PL/SQL Engine.