A Review on Query Optimization in Generic RDBMS
Purushottam Patel · International Journal for Research in Applied Science and Engineering Technology · 2019
In Database system, user makes query will be responded by the DBMS. Generally, there are varities of method for computing which response of the given query. It is the responsibility of the query processor to transform the query as entered by the user into an equivalent query that can be computed more efficiently. Query optimization is the process to find a good strategy or best strategy evaluation plan for processing a query. The Objective of this research is to discuss about technique used by the oracle for query and to present a comparative study of the various costs involve executing join and the LIKE predicate based queries. To present comparative study an empirical study is done on Oracle 9i and MS Access 2007.