Query Optimization Methods for Improve Query Execution Time using SQL Technologies

AHMED KHALAF, ZAGER ALSAEDI (2014) Query Optimization Methods for Improve Query Execution Time using SQL Technologies. In: International Conference on Advances In Computing, Electronics and Electrical Technology CEET 2014, 02 - 03 August, 2014, Kuala Lumpur, Malaysia.

[img]
Preview
Text
20150608_115519.pdf - Published Version

Download (803kB) | Preview
Official URL: https://www.seekdl.org/conferences/paper/details/3...

Abstract

Generally, the query optimizer cannot be accessed directly by users: once queries are submitted to database, and parsed by the parser, they are then passed to the query optimizer where optimization occurs. Each different way typically requires different processing time. The purpose of query optimization, which is an automated process, is to find the way to process a given query in minimum time. According to the basic operation of query such as scanning, aggregation, join. we present a four type of query a cross different size of tables to explain query performing through execution time to improve query execution time during optimization.

Item Type: Conference or Workshop Item (Paper)
Uncontrolled Keywords: Query optimization, Query execution time, SQL server 2012 technologies
Depositing User: Mr. John Steve
Date Deposited: 27 May 2019 08:31
Last Modified: 27 May 2019 08:31
URI: http://publications.theired.org/id/eprint/2776

Actions (login required)

View Item View Item