Practical Software Query Optimizing by Adapting Why and How?

Different methods have been presented because of the needs to query processing optimization in databases. The reason of these needs is to increase the amount of data and the queries sent to the Database Management System. Even though there are various methods presented to optimize queries, the problem is that in most of these methods, the execution plan is deleted after the query is conducted. This study tries to provide a method that uses optimized execution plan obtained from executing a query for the next executions or executing a similar query in order to reduce time needed for executing queries. The method presented in this study has been tested on real practical software databases and the results shows 11% improvement