EconPapers    
Economics at your fingertips  
 

Performance Enhancement using SQL Statement Tuning Approach

Hitesh Kumar Sharma () and S.C. Nelson ()
Additional contact information
Hitesh Kumar Sharma: University of Petroleum & Energy Studies, Dehardun, Uttarakhand, India
S.C. Nelson: University of Petroleum & Energy Studies, Dehardun, Uttarakhand, India

Database Systems Journal, 2017, vol. 8, issue 1, 12-21

Abstract: 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.

Keywords: SQL tuning; Oracle database; Explain Plan (search for similar items in EconPapers)
Date: 2017
References: View complete reference list from CitEc
Citations Track citations by RSS feed

Downloads: (external link)
http://www.dbjournal.ro/archive/27/27_2.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:aes:dbjour:v:8:y:2017:i:1:p:12-21

Access Statistics for this article

Database Systems Journal is currently edited by Ion Lungu

More articles in Database Systems Journal from Academy of Economic Studies - Bucharest, Romania Contact information at EDIRC.
Series data maintained by Adela Bara ().

 
Page updated 2017-09-29
Handle: RePEc:aes:dbjour:v:8:y:2017:i:1:p:12-21