Study and Analysis of Query Optimization using Selection, Projection and Join Statement in Generic RDBMS
Purushottam Patel · International Journal for Research in Applied Science and Engineering Technology · 2019
There has been extensive work in query optimization since the early '70s. It is hard to capture the breadth and depth of this large body of work in a short work. Therefore, we have decided to focus primarily on the optimization of SQL queries in relational database systems. The goal of this chapter is not to be comprehensive, but rather to explain the foundations and present samplings of significant work in this area. Relational query languages provide a high-level "declarative" interface to access data stored in relational databases. Over time, SQL has emerged as the standard for relational query languages. Two key components of the query evaluation component of a SQL database system are the query optimizer and the query execution engine.