Journals Proceedings

International Journal of Advances in Computer Science and Its Applications

Query Optimization Methods for Improve Query Execution Time using SQL Technologies



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

No fo Author(s) : 1
Page(s) : 62 - 65
Electronic ISSN : 2250 - 3765
Volume 4 : Issue 4
Views : 372   |   Download(s) : 136