Performance Enhancement using SQL Statement Tuning Approach

Tuning your SQL statements may be one of the most important tasks you can do to improve the performance of your Oracle system. By tuning your SQL statements to be as efficient as possible, you use your system to its full potential. Some of the things you can do to improve the efficiency of your SQL...

Full description

Bibliographic Details
Main Authors: Hitesh Kumar SHARMA, S.C. NELSON
Format: Article
Language:English
Published: Bucharest University of Economic Studies 2017-07-01
Series:Database Systems Journal
Subjects:
Online Access:http://www.dbjournal.ro/archive/27/27_2.pdf
Description
Summary:Tuning your SQL statements may be one of the most important tasks you can do to improve the performance of your Oracle system. By tuning your SQL statements to be as efficient as possible, you use your system to its full potential. Some of the things you can do to improve the efficiency of your SQL statements may involve as little effort as rewriting the SQL to take advantage of some property of your database or perhaps even changing the structure of the database itself.
ISSN:2069-3230
2069-3230