Selecting and tuning the optimal query form of different SQL commands

Hasan Ali Idhaim

International Journal of Business Information Systems, 2019, vol. 30, issue 1, 1-12

Abstract: This paper presents the proposed approach of SQL tuning plan and tool in database systems based on experiments using testing data workload in Oracle 11g XE; to get an optimal execution plan for a given SQL, statements based on process time consumed and statistics about the object related to tables are referenced in the statement. These statistics include the SQL command, running time consumption, tables themselves, their indexes, access methods, and other derived objects. The quality of final execution plan depends primarily on the quality of the information found about the SQL command to improve a poorly-performed query. This work contributes to research knowledge by proposing necessary knowledge and information about database tuning using a useful tool to evaluate SQL commands. The proposed approach helps researchers, database administrators and developers to assess the impact of their decisions in the selection of the optimal SQL statement form. Oracle 11g XE is taken for the experimentation purpose.

Keywords: Oracle 11g; SQL commands; SQL code tuning; SCT; query; tuning; throughput; evaluation; optimisation; DBA. (search for similar items in EconPapers)
Date: 2019
References: Add references at CitEc
Citations:

Downloads: (external link)
http://www.inderscience.com/link.php?id=97041 (text/html)
Access to full text is restricted to subscribers.

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:ids:ijbisy:v:30:y:2019:i:1:p:1-12

Access Statistics for this article

More articles in International Journal of Business Information Systems from Inderscience Enterprises Ltd
Bibliographic data for series maintained by Sarah Parker ().