InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is The Job Of An Optimizer? |
|
Answer» The job of an optimizer is to FIND the optimal/best PLAN to execute our DML STATEMENTS such as SELECT, INSERT, UPDATE and DELETE. Oracle USES CBO to help determine efficient methods to execute queries. The job of an optimizer is to find the optimal/best plan to execute our DML statements such as SELECT, INSERT, UPDATE and DELETE. Oracle uses CBO to help determine efficient methods to execute queries. |
|