InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Execution Plan Generation Phase/physical Execution Plan Execution Plan Generation Phase? |
|
Answer» During this phase, Oracle transforms the logical query plan into a physical query plan. The OPTIMIZER MAY be faced with a choice of SEVERAL ALGORITHMS to solve a query. It needs to choose the most efficient algorithm to answer a query, and it needs to determine the most efficient way to implement the operations. The optimizer determines the order in which it will perform the steps. During this phase, Oracle transforms the logical query plan into a physical query plan. The optimizer may be faced with a choice of several algorithms to solve a query. It needs to choose the most efficient algorithm to answer a query, and it needs to determine the most efficient way to implement the operations. The optimizer determines the order in which it will perform the steps. |
|