Which of the component module of DBMS does rearrangement and possible ordering of operations, eliminate redundancy in query and use efficient algorithms and indexes during the execution of a query?
1
query compiler
2
query optimizer
3
Stored data manager
4
Database processor