{"title":"基于索引的Transact-SQL查询的优化分析","authors":"Dominika Hodun, M. Skublewska-Paszkowska","doi":"10.5604/01.3001.0010.5210","DOIUrl":null,"url":null,"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.","PeriodicalId":142227,"journal":{"name":"Informatics, Control, Measurement in Economy and Environment Protection","volume":"7 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2017-09-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Optimisation analysis of Transact-SQL queries based on indexes\",\"authors\":\"Dominika Hodun, M. Skublewska-Paszkowska\",\"doi\":\"10.5604/01.3001.0010.5210\",\"DOIUrl\":null,\"url\":null,\"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.\",\"PeriodicalId\":142227,\"journal\":{\"name\":\"Informatics, Control, Measurement in Economy and Environment Protection\",\"volume\":\"7 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2017-09-30\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Informatics, Control, Measurement in Economy and Environment Protection\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.5604/01.3001.0010.5210\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Informatics, Control, Measurement in Economy and Environment Protection","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.5604/01.3001.0010.5210","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 0
摘要
． 本文以索引的使用为例，讨论了涉及修改查询语法的优化方法，为这些方法在实践中的应用提供了服务，并对测试结果进行了介绍和分析，并进行了比较。所有的查询都是在Microsoft SQL Server Management Studio 2014环境下进行的，使用的是Microsoft提供的AdventureWorksDW2012测试数据库。研究的对象是SELECT查询，因此返回所需的输出数据集。
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.
京公网安备 11010802042870号
京ICP备2023020795号-1
分享
求助内容：
应助结果提醒方式：
扫码关注我们
