The Examination of SQL Queries Efficiency in Chosen IT System
Saved in:
| Title: | The Examination of SQL Queries Efficiency in Chosen IT System |
|---|---|
| Authors: | Barczak, Krzysztof |
| Source: | Journal of Computer Sciences Institute; Vol. 28 (2023); 186-189 ; Journal of Computer Sciences Institute; Tom 28 (2023); 186-189 ; 2544-0764 |
| Publisher Information: | Lublin University of Technology |
| Publication Year: | 2023 |
| Collection: | Lublin University of Technology Journals |
| Subject Terms: | SQL query optimization, databases, testing, performance analysis |
| Description: | 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. |
| Document Type: | article in journal/newspaper |
| File Description: | application/pdf |
| Language: | English |
| Relation: | https://ph.pollub.pl/index.php/jcsi/article/view/3606/4163; https://ph.pollub.pl/index.php/jcsi/article/view/3606 |
| Availability: | https://ph.pollub.pl/index.php/jcsi/article/view/3606 |
| Rights: | Copyright (c) 2023 Krzysztof Barczak ; https://creativecommons.org/licenses/by-sa/4.0 |
| Accession Number: | edsbas.371ECB1E |
| Database: | BASE |
Nájsť tento článok vo Web of Science Be the first to leave a comment!