A Survey of Various Query Optimization Techniques

  title={A Survey of Various Query Optimization Techniques},
  author={Rini John and Nikita Palaskar},
  journal={International Journal of Computer Applications},
  • R. John, Nikita Palaskar
  • Published 15 September 2017
  • Computer Science
  • International Journal of Computer Applications
Data storage and retrieving the data on a specific time frame is critical for any application today. So an efficiently designed query lets the user get the results in the desired time and creates the credibility for the corresponding application. Here in this paper various techniques which are currently used or proposed in recent years and to get a better perspective in this field of query optimization are explored. Automatic external SQL-query optimization method is where the principle of… 
1 Citations

Tables from this paper

An improved query optimization process in big data using ACO-GA algorithm and HDFS map reduce technique
  • D. Kumar, V. Jha
  • Computer Science
    Distributed and Parallel Databases
  • 2020
An improved query optimization process in big data (BD) using the ACO-GA algorithm and HDFS map-reduce and it is shown that the algorithm outperformed other existent algorithms.


A database accelerator for energy-efficient query processing and optimization
A Tensilica RISC processor extended with an instruction set to accelerate basic database operators frequently used in modern database systems is presented, showing an 1000x energy improvement on selected database operators compared to state-of-the-art systems.
A JIT Compilation-Based Unified SQL Query Optimization System
This work proposes a unified SQL query optimization system using JIT compilation of OLTP, OLAP, and Stored Procedure workloads for enhanced performance on modern hardware.
External optimization of SQL-query under conditions of databases structural uncertainty
  • M. Zagirnyak, P. Kostenko
  • Computer Science
    2016 17th International Conference Computational Problems of Electrical Engineering (CPEE)
  • 2016
The paper deals with factors that influence the speed of data receiving in information systems and the method of automatic external SQL-query optimization, based on the principle of building a local model of controlled process, is described.
Optimization of Multiple Queries for Big Data with Apache Hadoop/Hive
  • Varun Garg
  • Computer Science
    2015 International Conference on Computational Intelligence and Communication Networks (CICN)
  • 2015
This manuscript proposes the use of Multi Query Optimization (MQO) technique to enhance the overall performance of Hadoop/Hive and transforms a set of interrelated HiveQL queries into new global queries that can produce the same results in remarkably smaller total execution times.
SQL query optimization in Content Based Image Retrieval systems
This paper presents a SQL query optimization method for Content Based Image Retrieval (CBIR) systems and it is tested on infantile hemangioma images.
Georg Ellguth; Andreas Dixius; Annett Ungethüm; Eric Mier; Benedikt Nöthen; Emil Matúš; Stefan Schiefer; Love Cederstroem; Fabian Pilz; Christian Mayr