OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES
Copyright policy )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 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.
- Polish Academy of Sciences Poland
- Lublin University of Technology Poland
- Institute of Computer Science Poland
queries, Environmental sciences, Environmental engineering, GE1-350, TA170-171, optimization, Transact-SQL
queries, Environmental sciences, Environmental engineering, GE1-350, TA170-171, optimization, Transact-SQL
selected citations These citations are derived from selected sources.This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).0 popularity This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.Average influence This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).Average impulse This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.Average
Citations provided by BIP!Popularity provided by BIP!