International Journal of Technology Enhancements and Emerging Engineering Research (ISSN 2347-4289)

IJTEEE >> Volume 3 - Issue 5, May 2015 Edition

International Journal of Technology Enhancements and Emerging Engineering Research  
International Journal of Technology Enhancements and Emerging Engineering Research

Website: http://www.ijteee.org

ISSN 2347-4289

Different Sql Query Optimizer Techniques

[Full Text]



Shani.S.Das, Rejimoan .R



Keywords: SQL Query; Optimizers; Query Tuning



ABSTRACT: Database contains huge amount of data. In order to make the query retrieval easier the content of the database is much organized. The query language used to retrieve the data stored in the database is SQL. In addition to the organized structure of data in the database there exists many query optimization techniques to make the query retrieval fast. SQL statements are declarative. That means SQL query can be written in different ways to retrieve the same query result. It is trivial to find which organization of the SQL query retrieve is query result with a minimum time. This paper discusses various optimizer approaches used for query retrieval from database and finds the better approach among them. The various query optimizer approaches discussed in this paper is Cost based ,Heuristic based and Learning based . Cost based approach focus on the statistics of the relations . Heuristic approach works based on certain predefined rules and Learning based approach works by correcting the incorrect statistics used to execute the query.



[1] Grant Fritchey ,SQL Server Execution Plans, Simple Talk Publishing September 2012

[2] A. Hameurlain and F. Morvan Evolution of Query Optimization Methods Springer- Verlag Berlin Heidelberg pp. 211242, 2009

[3] Michael L. Rupley, Jr. Introduction to Query Processing and Optimization,2005

[4] Michael Stillger,, Guy Lohman, Volker Markl, Mokhtar Kandil LEO DB2s LEarning Optimizer Proceedings of the 27th VLDB Conference, Roma, Italy, 2001

[5] Dave Martin , Barry Thorn , Steve Tlusty , JaeHee Yang Preparing for Tuning the SQL Query Engine on DB2 for i5/OS Redbooks

[6] Saurabh Kumar,Gaurav Khandelwal,Arjun Varshney,Mukul Arora ,Cost- Based Query Optimization with Heuristics IJSCR Volume 2, Issue 9, September-2011

[7] Surajit Chaudhuri An Overview of Query Optimization in Relational Systems Microsoft Research

[8] An Oracle White Paper November 2010 SQL Plan Management in Oracle Database 11g

[9] Oracle 11g the complete reference

[10] Predicting Multiple Metrics for Queries: Better Decisions Enabled by Machine Learning, 2012

[11] Mert Akdere, Ugur Cetintemel, Matteo Riondato, Eli Upfal, Stanley B. ZdonikLearning-based Query Performance Modeling and Prediction 2012 IEEE 28th International Conference on Data Engineering