An Analysis on Query Optimization in Distributed Database
Joshi Janki · International Journal of Modern Trends in Engineering and Research · 2014
The query optimizer is a significant element in today’s relational database management system. This element is responsible for translating a user-submitted query commonly written in a non-procedural language-into an efficient query evaluation program that can be executed against the database. This research paper describes architecture steps of query process and optimization time and memory usage. Key goal of this paper is to understand the basic query optimization process and its architecture.