6 ms·
That's not entirely correct. A hard parse causes the optimizer to do bind variable peeking, i.e. it chooses the execution plan based on the bind variable value.
by cneu 7y ago
That's not entirely correct. A hard parse causes the optimizer to do bind variable peeking, i.e. it chooses the execution plan based on the bind variable value.
https://docs.oracle.com/cd/E11882_01/server.112/e41573/optimops.htm#PFGRF94588 https://docs.oracle.com/cd/E11882_01/server.112/e41573/optim...
- pif 7y agoFrom the same source: When choosing a plan, the optimizer only peeks at the bind value during the hard parse. This plan may not be optimal for all possible values.