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

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

Download

Published : 2017-09-30


Hodun, D., & Skublewska-Paszkowska, M. (2017). OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES. Informatyka, Automatyka, Pomiary W Gospodarce I Ochronie Środowiska, 7(3), 29-32. https://doi.org/10.5604/01.3001.0010.5210

Dominika Hodun  dominikahodun@gmail.com
Lublin University of Technology, Institute of Computer Science  Poland
Maria Skublewska-Paszkowska 
Lublin University of Technology, Institute of Computer Science  Poland