The Examination of SQL Queries Efficiency in Chosen IT System
Krzysztof Barczak · Journal of Computer Sciences Institute · 2023
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.