query optimization in dbms

It is a phase which identifies a plan for evaluation query that has the least estimated cost. We can use query optimizer when there is lot of algorithms and methods…