Open AccessOPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES
Author(s) -
Dominika Hodun,
Maria SkublewskaPaszkowska
Publication year - 2017
Publication title -
informatyka, automatyka, pomiary w gospodarce i ochronie środowiska
Language(s) - English
Resource type - Journals
eISSN - 2391-6761
pISSN - 2083-0157
DOI - 10.5604/01.3001.0010.5210
Subject(s) - computer science , sql , language integrated query , microsoft visual studio , database , sql server , set (abstract data type) , syntax , object (grammar) , user defined function , information retrieval , data transformation services , programming language , query by example , world wide web , data mining , software , artificial intelligence , web search query , search engine
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.