Oracle Cost Based Optimizer Plans

HardPipelines00:00

Practice interviewer

In session

5 left

00:00

Your question is Oracle Cost Based Optimizer Plans. Take a moment with it on the right.

Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).

You need to log in / sign up to chat or submit.

Problem

Explain why the Oracle Cost Based Optimizer chooses the execution plans for SQL and explain the different options used and what their impact is on performance.