Zobrazit v EDS

The Examination of SQL Queries Efficiency in Chosen IT System

Uloženo v:

Podrobná bibliografie
Název:	The Examination of SQL Queries Efficiency in Chosen IT System
Autoři:	Barczak, Krzysztof
Zdroj:	Journal of Computer Sciences Institute; Vol. 28 (2023); 186-189 ; Journal of Computer Sciences Institute; Tom 28 (2023); 186-189 ; 2544-0764
Informace o vydavateli:	Lublin University of Technology
Rok vydání:	2023
Sbírka:	Lublin University of Technology Journals
Témata:	SQL query optimization, databases, testing, performance analysis
Popis:	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.
Druh dokumentu:	article in journal/newspaper
Popis souboru:	application/pdf
Jazyk:	English
Relation:	https://ph.pollub.pl/index.php/jcsi/article/view/3606/4163; https://ph.pollub.pl/index.php/jcsi/article/view/3606
Dostupnost:	https://ph.pollub.pl/index.php/jcsi/article/view/3606
Rights:	Copyright (c) 2023 Krzysztof Barczak ; https://creativecommons.org/licenses/by-sa/4.0
Přístupové číslo:	edsbas.371ECB1E
Databáze:	BASE

Popis
Abstrakt:	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.