Introduction to Query Processing and Optimization

All database systems must be able to respond to requests for information from the user?i.e. process queries. Obtaining the desired information from a database system in a predictable and reliable fashion is the scientific art of Query Processing. Getting these results back in a timely manner deals with the technique of Query Optimization .This paper will introduce the reader to the basic concepts of query processing and query optimization in the relational database domain. How a database processes a query as well as some of the algorithms and rule ?sets utilized to produce more efficient queries will be presented .