An empirical study of SQL query optimization techniques
Megha U. Patel · Minds at UW (University of Wisconsin) · 2019
It is necessary to have databases and datasets in all the applications, websites and programs to support their Modern Information System (MIS).These MIS systems use Relational Database Management System (R-DBMS) to store data and Procedure Language/Structured Query Language (PL/SQL) to retrieve, add or generate data.The SQL query may not perform well on big data or complex data tables.Hence, it is important to use improved SQL queries.This paper describes different SQL query optimization methods based on different scenarios and examples.This paper also describes parse trees for each technique.It includes how the parse tree is affected by optimized query.It also shows the difference between parse trees before applied optimized method and after.