Query Optimizer in Database Management Systems (DBMS) When it comes to database management systems (DBMS),…