The Examination of SQL Queries Efficiency in Chosen IT System

Article Sidebar

Open full text

PDF
Published: Sep 30, 2023
DOI: https://doi.org/10.35784/jcsi.3606
Crossref
Scopus
Google Scholar
Europe PMC
Articles

Archives

2023

Main Article Content

DOI

https://doi.org/10.35784/jcsi.3606

Authors

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

References

Article Details

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