期刊名称：International Journal of Computer Science Issues
印刷版ISSN：1694-0784
电子版ISSN：1694-0814
出版年度：2012
卷号：9
期号：2
出版社：IJCSI Press
摘要：In relational database large information is maintained and organized so that user can get the desired information in predictable and reliable fashion through the query processing. Retrieving these results in timely manner is Query Optimization. Optimization is a process of choosing most efficient way to execute a SQL query. This is important step in processing of any data manipulation language because in RDBMS, as in large and complicated system performance is key issue. Its an issue that you need to deal with on an ongoing basis so performance must be built in. This paper will provide the reader general concepts of query optimization in relational database system. I will define the implementation plan using join ordering to broaden the potential of database engine through the use of Genetic algorithm in the field of database area in the context of query optimization [12].
