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: | , |
|---|---|
| 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 |
| _version_ | 1811267778948104192 |
|---|---|
| author | Dominika Hodun Maria Skublewska-Paszkowska |
| author_facet | Dominika Hodun Maria Skublewska-Paszkowska |
| author_sort | Dominika Hodun |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-04-12T21:08:46Z |
| format | Article |
| id | doaj.art-e24ac425aa894f5297a6ea766644c814 |
| institution | Directory Open Access Journal |
| issn | 2083-0157 2391-6761 |
| language | English |
| last_indexed | 2024-04-12T21:08:46Z |
| publishDate | 2017-09-01 |
| publisher | Lublin University of Technology |
| record_format | Article |
| series | Informatyka, Automatyka, Pomiary w Gospodarce i Ochronie Środowiska |
| spelling | doaj.art-e24ac425aa894f5297a6ea766644c8142022-12-22T03:16:38ZengLublin University of TechnologyInformatyka, Automatyka, Pomiary w Gospodarce i Ochronie Środowiska2083-01572391-67612017-09-017310.5604/01.3001.0010.5210OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXESDominika Hodun0Maria Skublewska-Paszkowska1Lublin University of Technology, Institute of Computer ScienceLublin University of Technology, Institute of Computer ScienceThe 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.https://ph.pollub.pl/index.php/iapgos/article/view/1362Transact-SQLoptimizationqueries |
| spellingShingle | Dominika Hodun Maria Skublewska-Paszkowska OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES Informatyka, Automatyka, Pomiary w Gospodarce i Ochronie Środowiska Transact-SQL optimization queries |
| title | OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES |
| title_full | OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES |
| title_fullStr | OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES |
| title_full_unstemmed | OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES |
| title_short | OPTIMISATION ANALYSIS OF TRANSACT-SQL QUERIES BASED ON INDEXES |
| title_sort | optimisation analysis of transact sql queries based on indexes |
| topic | Transact-SQL optimization queries |
| url | https://ph.pollub.pl/index.php/iapgos/article/view/1362 |
| work_keys_str_mv | AT dominikahodun optimisationanalysisoftransactsqlqueriesbasedonindexes AT mariaskublewskapaszkowska optimisationanalysisoftransactsqlqueriesbasedonindexes |