As we all know, optimizer parse the statement to provide a plan, but to provide that Oracle Optimizer has to go through different phases called Parse, Execute, Fetch.
1. Parsing has three phases again,
Compiler: Compiles the statement to oracle readable format or oracle understandable state.
Estimator: Look out the […]
Follow Me!!!