OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES
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 m...
Main Authors: | Dominika Hodun, Maria Skublewska-Paszkowska |
---|---|
Format: | Article |
Language: | English |
Published: |
Lublin University of Technology
2017-09-01
|
Series: | Informatyka, Automatyka, Pomiary w Gospodarce i Ochronie Środowiska |
Subjects: | |
Online Access: | https://ph.pollub.pl/index.php/iapgos/article/view/1362 |
Similar Items
-
Optimizing queries in SQL Server 2008
by: Ion LUNGU, et al.
Published: (2010-05-01) -
INDEXES SELECTION FOR BLOCKS OF RELATED SQL QUERIES
by: Radosław BOROŃSKI
Published: (2012-06-01) -
Query Optimization Techniques in Microsoft SQL Server
by: Costel Gabriel CORLATAN, et al.
Published: (2014-09-01) -
Ways to optimize SQL queries to improve database performance in high–load systems
by: Я. Корнага, et al.
Published: (2021-05-01) -
Evaluation of Sub Query Performance in SQL Server
by: Oktavia Tanty, et al.
Published: (2014-03-01)