OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES
Dominika Hodun
dominikahodun@gmail.comLublin University of Technology, Institute of Computer Science (Poland)
Maria Skublewska-Paszkowska
Lublin University of Technology, Institute of Computer Science (Poland)
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, queriesReferences
Ben-Gan I.: Microsoft SQL Server 2012. Podstawy języka T-SQL. APN Solid, 2012.
Google Scholar
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.
Google Scholar
Morzy T.: Optymalizacja zapytań. http://wazniak.mimuw.edu.pl/images/c/c7/BD-2st-1.2-w12.tresc-1.1.pdf
Google Scholar
Nevarez B.: Microsoft SQL Server 2014. Optymalizacja zapytań. Helion, 2014.
Google Scholar
Ptasznik A.: Optymalizacja zapytań SQL. Warszawska Wyższa Szkoła Informatyki, 2009.
Google Scholar
Tow D.: SQL Optymalizacja. Helion, 2014.
Google Scholar
Wojciechowski M., Zakrzewicz M.: Kosztowy optymalizator zapytań. http://www.cs.put.poznan.pl/mzakrzewicz/pubs/plsem02.pdf
Google Scholar
Authors
Dominika Hodundominikahodun@gmail.com
Lublin University of Technology, Institute of Computer Science Poland
Authors
Maria Skublewska-PaszkowskaLublin University of Technology, Institute of Computer Science Poland
Statistics
Abstract views: 255PDF downloads: 101
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Most read articles by the same author(s)
- Paweł Grzmil , Maria Skublewska-Paszkowska, Edyta Łukasik, Jakub Smołka, PERFORMANCE ANALYSIS OF NATIVE AND CROSS-PLATFORM MOBILE APPLICATIONS , Informatyka, Automatyka, Pomiary w Gospodarce i Ochronie Środowiska: Vol. 7 No. 2 (2017)
- Kamil Gut, Maria Skublewska-Paszkowska, Edyta Łukasik, Jakub Smołka, COMPARISON OF PROGRAMMING LANGUAGES ON THE IOS PLATFORM IN TERMS OF PERFORMANCE , Informatyka, Automatyka, Pomiary w Gospodarce i Ochronie Środowiska: Vol. 7 No. 3 (2017)
- Michał Oseńko, Jakub Smołka, Maria Skublewska-Paszkowska, Edyta Łukasik, A METHOD FOR VISUALIZATION OF 3D MOTION DATA USING A MOBILE DEVICE , Informatyka, Automatyka, Pomiary w Gospodarce i Ochronie Środowiska: Vol. 7 No. 3 (2017)
- Jakub Smołka, Przemysław Troć, Maria Skublewska-Paszkowska, Edyta Łukasik, IMPROVED MOTION TYPE IDENTIFICATION METHOD USING MOBILE DEVICE SENSORS , Informatyka, Automatyka, Pomiary w Gospodarce i Ochronie Środowiska: Vol. 6 No. 2 (2016)
- Maria Skublewska-Paszkowska, Jakub Smołka, COMPARISON OF THE SELECTED MOTION INTERPOLATION METHODS , Informatyka, Automatyka, Pomiary w Gospodarce i Ochronie Środowiska: Vol. 3 No. 3 (2013)
- Jakub Smołka, Maria Skublewska-Paszkowska, Marcin Badurowicz, Edyta Łukasik, MOBILE DEVICES AS ACCELERATION RECORDERS , Informatyka, Automatyka, Pomiary w Gospodarce i Ochronie Środowiska: Vol. 5 No. 1 (2015)
