OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES
Article Sidebar
Open full text
Published:
Sep 30, 2017
Issue Vol. 7 No. 3 (2017)
Articles
-
CLASSIFICATION OF THE FUNCTIONALITY AND THE SCHEMES OF THE ACOUSTIC EMISSION SOURCES LOCALIZATION
5-7
-
A METHOD OF COMPARATIVE EVALUATION OF CONTROL SYSTEMS BY THE SET OF PERFORMANCE MEASURES
8-10
-
NUMERICAL ASPECTS OF THE SECONDARY MAGNETIC FIELD MAPPING IN MAGNETIC INDUCTION TOMOGRAPHY
11-14
-
INTO THE FAST TOMOGRAPHIC POSTPROCESSING IN TOKAMAKS
15-18
-
NUMERICAL COMPUTATIONS OF THE FRACTIONAL DERIVATIVE IN IVPS, EXAMPLES IN MATLAB AND MATHEMATICA
19-22
-
SIMULATION AND COMPARISON OF SELECTED FAST CHARGER TOPOLOGIES
23-28
-
OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES
29-32
-
COMPARISON OF PROGRAMMING LANGUAGES ON THE IOS PLATFORM IN TERMS OF PERFORMANCE
33-36
-
A METHOD FOR VISUALIZATION OF 3D MOTION DATA USING A MOBILE DEVICE
37-42
-
K-MEANS CLUSTERING IN TEXTURED IMAGE: EXAMPLE OF LAMELLAR MICROSTRUCTURE IN TITANIUM ALLOYS
43-46
-
APPLYING A Q-GRAM BASED MULTIPLE STRING MATCHING ALGORITHM FOR APPROXIMATE MATCHING
47-50
-
WEB SERVER LATENCY REDUCTION STUDY
51-55
-
ALTERNATIVE TERMINATION CRITERION FOR K-SPECIFIED CRISP DATA CLUSTERING ALGORITHMS
56-59
-
THE DEPENDENCE BETWEEN THE NUMBER OF ROUNDS AND IMPLEMENTED NODES IN LEACH ROUTING PROTOCOL-BASED SENSOR NETWORKS
60-63
-
MOBILE APPLICATION SUPPORTING DOPPLER ULTRASOUND EXAMINATION
64-67
-
ANALYSIS OF SKIN DISEASES USING MAPPING COLOR SPACES
68-71
-
ARTIFICIAL NEURAL NETWORKS AS A MOTORICAL ASSOCIATIVE MEMORY FOR HUMANOID ROBOT HAND
72-77
-
THE INTENSITY OF DAYLIGHT IN SCHOOL BUILDING
78-81
-
POWER BALANCE AND HOLONOMICITY OF SWITCHED RELUCTANCE MOTOR
82-85
-
MODIFIED METHOD OF INTRODUCING THRESHOLDING FUNCTIONS IN MODELS OF RELATIONAL FUZZY COGNITIVE MAPS
86-89
-
ECONOMIC AND PRACTICAL ASPECTS OF USE OF AIR SOURCE HEAT PUMPS
90-93
-
IMPACT OF THE REFRIGERANT SELECTION ON THE COLD STORAGE POSSIBILITIES IN A THERMAL ENERGY ACCUMULATOR OF AN URBAN BUS
94-98
-
USING NEURAL NETWORKS AND DEEP LEARNING ALGORITHMS IN ELECTRICAL IMPEDANCE TOMOGRAPHY
99-102
-
THE ANALYSIS OF SENSORY PLATFORM FOR USE IN THE INTERNET OF THINGS
103-106
Main Article Content
DOI
Authors
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
Article Details
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
