The Examination of SQL Queries Efficiency in Chosen IT System

Krzysztof Barczak

krzysztof.barczak@pollub.edu.pl
Computer Science (Poland)

Abstract

Optimization of SQL queries is an important part of any system using a database. Several different optimization methods have been selected and presented in this article, The research was conducted on the MS SQL database engine. The execution times of SQL queries were carefully examined according to defined criteria, then performance optimization was done, followed by repeated tests to obtain results after the optimization. Finally, the results were compared through which conclusions were drawn.


Keywords:

SQL query optimization, databases, testing, performance analysis

G. Dziewit, J. Korczyński, M. Skublewska-Paszkowska, Performance analysis of relational databases Oracle and MS SQL based on desktop application, Journal of Computer Sciences Institute 8 (2018) 263-269, https://doi.org/10.35784/jcsi.693.
DOI: https://doi.org/10.35784/jcsi.693   Google Scholar

M. Woch, Optymalizacja Microsoft SQL server przy współpracy z Microsoft Dynamic NAV, Studia Informatica 28(2) (2007) 17-29.
  Google Scholar

E. Noble, Pro T-SQL 2019, Apress, Berkeley, 2020.
DOI: https://doi.org/10.1007/978-1-4842-5590-2   Google Scholar

W. Bolesta, Analysis of query execution speed in the selected NoSQL databases, Journal of Computer Sciences Institute 7 (2018) 138-141, https://doi.org/10.35784/jcsi.662.
DOI: https://doi.org/10.35784/jcsi.662   Google Scholar

Otomoto, https://www.otomoto.pl, [01.11.2022].
  Google Scholar

Model MVC, https://vavatech.pl/technologie/architektura/mvc, [01.11.2022].
  Google Scholar

SQL - INDEX, https://www.plukasiewicz.net/SQL, [01.11.2022].
  Google Scholar

Download


Published
2023-09-30

Cited by

Barczak, K. (2023). The Examination of SQL Queries Efficiency in Chosen IT System. Journal of Computer Sciences Institute, 28, 186–189. https://doi.org/10.35784/jcsi.3606

Authors

Krzysztof Barczak 
krzysztof.barczak@pollub.edu.pl
Computer Science Poland

Statistics

Abstract views: 190
PDF downloads: 199