Abstract:
The paper identifies various issues and factors in Query Processing and Optimization while choosing the best Database Execution Plan. Our approach depends on various phases of query processing and optimization, heuristic estimation techniques and cost function for identifying the best execution plan. This paper contains the review report on various phases of query processing, goals of optimizer, various rules for heuristic optimization and cost components.
