OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES
Abstract
The article presents a discussion of the optimisation methods involving the modification of query syntax on the example of the use of indexes that served for the application of the methods in practice, and the presentation and analysis of the test results and their comparison. All the queries were made in a Microsoft SQL Server Management Studio 2014 environment, using the AdventureWorksDW2012 test database provided by Microsoft. The object of the research were SELECT queries, which consequently returned the desired set of output data.
Keywords
Transact-SQL; optimization; queries
References
Ben-Gan I.: Microsoft SQL Server 2012. Podstawy języka T-SQL. APN Solid, 2012.
Bertrand A., Stellato E., Berry G., Hall J., Sack J., Kehayias J., Kline K., Randal P., White P.: High performance techniques for Microsoft SQL Server. SQL Sentry. , Tom 1-5, 2013.
Morzy T.: Optymalizacja zapytań. http://wazniak.mimuw.edu.pl/images/c/c7/BD-2st-1.2-w12.tresc-1.1.pdf
Nevarez B.: Microsoft SQL Server 2014. Optymalizacja zapytań. Helion, 2014.
Ptasznik A.: Optymalizacja zapytań SQL. Warszawska Wyższa Szkoła Informatyki, 2009.
Tow D.: SQL Optymalizacja. Helion, 2014.
Wojciechowski M., Zakrzewicz M.: Kosztowy optymalizator zapytań. http://www.cs.put.poznan.pl/mzakrzewicz/pubs/plsem02.pdf
Lublin University of Technology, Institute of Computer Science Poland
Lublin University of Technology, Institute of Computer Science Poland
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
