Mumbai University > Information Technology > Sem 3 > Database Management System

Marks: 10M

Year: Dec 2015

• Query optimization is one of the most important tasks of a relational DBMS.
• The Query optimizer generates alternative plans and chooses the best plan with the least estimated cost.
• The query optimizer module is used to find out an execution plan which is the execution strategy to retrieve the result …