文章基本信息

标题：EVALUATION SUBQUERY METHODS IN MICROSOFT SQL SERVER 2008
本地全文：下载
作者：TANTY OKTAVIA
期刊名称：Journal of Theoretical and Applied Information Technology
印刷版ISSN：1992-8645
电子版ISSN：1817-3195
出版年度：2014
卷号：64
期号：1
出版社：Journal of Theoretical and Applied
摘要：Frequently user compiles a query to satisfy business process needs, whether directly using DBMS or connecting into application system. There are many methods that can be used to generate desired results to support transaction, but all the query processing should be run effectively and efficiently. A significant aspect of query processing is how to choose an efficient execution strategy to minimize resource usage. Based on competitive environment in industry, many companies compete with each other to be a number one. For this reason, company doing a lot of experiments, in order to accomplish a visions and mission objectives. One of those is increasing performance of the system to support daily activities. Nowadays, most of business process in company already integrated with information technology. All of data is consolidated by database, so user easily doing their job. According to this fact, user does not matter about how many transactions to be process per day, but how much time they need to process that transaction is the priority concern. Because of that, query optimization techniques become more important to be applied in many applications. In this research focused on measurement effectiveness of the method sub query which can be applied to reach optimal execution and present a comparative study of various cost to declare Sub query. This study based on Microsoft SQL Server 2008 platforms.
关键词：Query Processing; Microsoft SQL Server 2008; Sub query; Cost Control