Experiment of Query Optimization Techniques to get the Efficient Query

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Year of Publication: 2017
Luqman Hakim, Suryanto Nugroho, Sigit Hadi Waluyo

Luqman Hakim, Suryanto Nugroho and Sigit Hadi Waluyo. Experiment of Query Optimization Techniques to get the Efficient Query. International Journal of Computer Applications 170(10):6-10, July 2017. BibTeX

	author = {Luqman Hakim and Suryanto Nugroho and Sigit Hadi Waluyo},
	title = {Experiment of Query Optimization Techniques to get the Efficient Query},
	journal = {International Journal of Computer Applications},
	issue_date = {July 2017},
	volume = {170},
	number = {10},
	month = {Jul},
	year = {2017},
	issn = {0975-8887},
	pages = {6-10},
	numpages = {5},
	url = {http://www.ijcaonline.org/archives/volume170/number10/28104-2017914888},
	doi = {10.5120/ijca2017914888},
	publisher = {Foundation of Computer Science (FCS), NY, USA},
	address = {New York, USA}


Optimization of a database query becomes one of the critical phases in data processing handling. Database optimization is needed to make a structured query language more concise and efficient. This study aims to conduct experiments with structured query language modifications compared to structured query language examples commonly used in the manufacture of software. This study uses a database with a record large enough to try to implement its SQL. The results of the experiments of all modified query writing are more efficient than the queries used by the information system in the database regarding data processing time.


  1. Wenjiao, B, Jiming, L, Jichao, T & LI, S. Query Optimization of Distributed Database Based on Parallel Genetic Algorithm and Max-Min Ant System. 2015 8th International Symposium on Computational Intelligence and Design, 2015.
  2. Habimana, J. 2015. Query Optimization Techniques - Tips For Writing Efficient And Faster SQL Queries. International Journal Of Scientific & Technology Research, 4, 22-26.
  3. Gordon C. Everest. 2005 Fundamentals of Database System Benyamin Tokyo.
  4. ARIPIN 2010. Meningkatkan Efektifitas Pengelolaan Database Dengan Optimasi SQL. Techno.Com, 9.
  5. Haas, S., Arnold, O., Scholzey, S., H¨Oppnery, S., Ellguthy, G., Andreas Dixiusy, Ungeth¨Umz, A., Mierz, E., N¨Othen, B., Mat´Uˇs, E., Schiefery, S., Cederstroemy, L., Pilzx, F., Mayry, C., Sch¨Uffnyy, R. E., Lehnerz, W. & Fettweis , G. P. 2016. A Database Accelerator For Energy-Efficient Query Processing And Optimization.
  6. Lakshmi, S. V. & Vatsavayi, V. K. Query Optimization Using Clustering And Genetic Algorithm For Distributed Databases. 2016 International Conference On Computer Communication And Informatics (Iccci -2016), 2016 Coimbatore, India.


Database Relation, Structured Query Language, Database Optimization, Database Management System.