Conference Proceedings

International Conference on Advances In Computing, Electronics and Electrical Technology CEET 2014

Query Optimization Methods for Improve Query Execution Time using SQL Technologies

Author(s) : AHMED KHALAF ZAGER ALSAEDI

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.

Conference Title : International Conference on Advances In Computing, Electronics and Electrical Technology CEET 2014
Conference Date(s) : 02 - 03 August, 2014
Place : Hotel G Tower, Kuala Lumpur, Malaysia
No fo Author(s) : 1
DOI : 10.15224/978-1-63248-005-7-30
Page(s) : 17 - 20
Electronic ISBN : 978-1-63248-005-7
Views : 941   |   Download(s) : 207