A Study on Optimization Techniques and Query Execution Operators That Enhances Query Performance
Main Article Content
Abstract
Now a day’s Query Optimization is a key technology for every application from operational systems to data warehouse and from analytical systems to content management systems. Query Optimization is of great importance for the performance of a relational database, especially for the execution of complex SQL statements. The performance of database systems is critically dependent upon the efficiency of Optimization techniques and Query Execution Operators. Thus we present a detailed study of the various Optimization techniques and Query execution Operators that helps to enhance the query performance. A survey of the available work into this field is also given. This detailed study helps to choose an Optimization strategy that best suits your query environment. This study facilitates the enhancement of query performance by determining the best optimization strategy and helping us to build a query optimizer model. In this paper we focus on the various Optimization techniques, Components of query optimizer and the Query execution operators that are used for the enhancement of query performance.
Keywords: Query Optimization, Query Optimizer, Query Optimization Techniques, Query Execution Operators and Optimization Strategy
Downloads
Article Details
COPYRIGHT
Submission of a manuscript implies: that the work described has not been published before, that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication, the authors agree to automatic transfer of the copyright to the publisher.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work
- The journal allows the author(s) to retain publishing rights without restrictions.
- The journal allows the author(s) to hold the copyright without restrictions.